| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Unique in Pivot Table
Hi,
I have a large list - and was wondering how to count unique numbers (eg. customer IDs) in a pivot table. I have arranged my data so each location is shown in the rows. Can this be done? So far I can only get the data field to count the total entries, but not unique entries by location. If not - is there a way to do this with a formula? Any help appreciated. Nelson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Count in Pivot Table | Excel Worksheet Functions | |||
| Pivot Table Unique Count | Excel Worksheet Functions | |||
| How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions | |||
Threaded Mode
