Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have data like this:
ABC BOX1 ABC BOX1 EFG BOX2 HIJ BOX3 KLM BOX4 And would like to use the Pivot Table to count the unique values in ColA: BOX1 1 BOX2 1 BOX3 1 BOX4 1 For some reason, I am getting the following: BOX1 2 BOX2 1 BOX3 1 BOX4 1 Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |