count unique value

[whoiswct]

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


Sent from my phone using Tapatalk

[lumia]

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)

[JoePublic]

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.

[Kevin@Radstock]

Hi whoiswct

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

[JoePublic]

Just be aware that you will then have an OLAP pivot table which has a few drawbacks (such as no native date grouping)

[Herbds7]

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