| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
When trying to analyze raw data, I have multiple instances of clients and
want the pivot table to count clients rather than count each instance. Example: AAAA-1 AAAA-1 BBBB-1 CCCC-1 CCCC-1 I want the pivot table to return 3 clients, not 5. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table question
Hi, you could use this formula, property of T. Valko instead of a pivot table:
=SUMPRODUCT((A1:A50<"")/COUNTIF(A1:A50,A1:A50&"")) -- Alex *Remember to click "yes" if this post helped you. Thank you! "Jugglertwo" wrote: When trying to analyze raw data, I have multiple instances of clients and want the pivot table to count clients rather than count each instance. Example: AAAA-1 AAAA-1 BBBB-1 CCCC-1 CCCC-1 I want the pivot table to return 3 clients, not 5. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table question | Charts and Charting in Excel | |||
| Pivot Table Question | Charts and Charting in Excel | |||
| Pivot Table Question | Excel Worksheet Functions | |||
| Pivot Table Question | New Users to Excel | |||
| Pivot Table Question : If statment in Pivot Table?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
