Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PivotTable Row Count
I have a PivotTable sorted into a list of Names, each associated with a set
of unique account numbers. I.e., the row area of the table is NameAccount Number. This gives me the list of unique account numbers associated with each name, but I can't find a way of totaling the number of unique numbers per name. Using a "count of account numbers" in the Data field doesn't work, as each account number may appear multiple times in the data that the pivot table is based on. Any ideas/suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivottable won't count blank values | Excel Discussion (Misc queries) | |||
pivottable: Why do I get Count instead of Sum when numeric data | Excel Discussion (Misc queries) | |||
Pivottable to count non-zeros | Excel Discussion (Misc queries) | |||
Why does my Excel pivottable uses count instead of sum | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions |