count unique value

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
without change the data, how can I count the unique value by pivot table?


Sent from my phone using Tapatalk
 
Pivot table

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)
 
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.
 
Hi whoiswct

What version of Excel are you using! If it is 2013, have a look here
 
Just be aware that you will then have an OLAP pivot table which has a few drawbacks (such as no native date grouping)
 
Back
Top