| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Unique Values in Pivot table
I'm making a pivot table that counts the number of accounts#'s. Unfortunately
the account#'s are sometimes duplicated. Without altering the original data, is there a way I can do something in my pivot table so that it only counts unique account numbers and discards the dupes? Thanks. IE: Name #of new accounts Bob 6 Joe 3 Sam 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique Pivot Table Count | Excel Discussion (Misc queries) | |||
| Unique count in Pivot Table | Excel Worksheet Functions | |||
| Count Unique using Pivot Table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
Threaded Mode
