Results 1 to 6 of 6

Thread: count unique value

  1. #1

    count unique value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    without change the data, how can I count the unique value by pivot table?


    Sent from my phone using Tapatalk

  2. #2

    Red face Pivot table

    Quote Originally Posted by whoiswct View Post
    without change the data, how can I count the unique value by pivot table?


    Sent from my phone using Tapatalk
    Ans: Unique value can extract with conditional formatting. Go to home tab > conditional formatting > Highlight cell values > duplicate value > select Unique in drop down > ok. (works in v.2007 2010)

  3. #3
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    170
    Articles
    0
    Quote Originally Posted by whoiswct View Post
    without change the data, how can I count the unique value by pivot table?
    You can't (unless you are using PowerPivot). You have to add formulas to the source data.
    Circumference of a circle = 2πrē



    ēthe circle's radius

  4. #4
    Hi whoiswct

    What version of Excel are you using! If it is 2013, have a look here

  5. #5
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Location
    Askew
    Posts
    170
    Articles
    0
    Just be aware that you will then have an OLAP pivot table which has a few drawbacks (such as no native date grouping)
    Circumference of a circle = 2πrē



    ēthe circle's radius

  6. #6
    Excel 2010 with free PowerPivot Add-In
    Count unique values.
    Examples with regular PivotTable and
    PowerPivot DAX DistinctCount()
    http://58918aa17d4002474361-7ac2b7ee...04_17_13a.xlsx
    If you get *.zip, don't unzip, just rename *.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •