Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting a total in a pivot table, excluding the duplicates.
I had following formula to give me the count of the single instances
of a repeated name. I am trying to upgrade my report and use a pivot table, but wonder how to use this formula/or a simpler way to count only the unique instance in a column/header. Any advice? =SUM(IF(FREQUENCY(IF(LEN(B:B)0,MATCH(B:B,B:B,0)," "), IF(LEN(B:B)0,MATCH(B:B,B:B,0),""))0,1)) Example: Names in column A. Codes in column B. Some of the codes in column B are repeated. In my pivot, I want to roll up how many codes (excluding the duplicates) each person had. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table grouping excluding weekends | Excel Discussion (Misc queries) | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Requesting Help with Counting in a Pivot but Excluding Duplicates | Excel Worksheet Functions | |||
Pivot Table Top 20 excluding specific items | Excel Discussion (Misc queries) | |||
% of Running Total to Grand Total in Pivot Table | Excel Programming |