Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique records in pivot table - formula?
Hi there,
I want to count how many times a specific ClockNo appears per Process Code in a table of values. However, I cannot add columns to my table, and the following formula added to my pivot table returns a #N/A error... Please help: =sum(if(frequency(match(ClockNo, Clockno, 0), match(ClockNo, ClockNo, 0))0,1)) what am i doing wrong - also I don't really want to use the sumproduct formula as it simply takes too long to recalc... Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique records in Pivot Table | Excel Discussion (Misc queries) | |||
pivot count unique records only | Excel Discussion (Misc queries) | |||
unique records in pivot table | Excel Discussion (Misc queries) | |||
Filter out unique records from pivot | Excel Worksheet Functions | |||
unique records in Pivot Table | Excel Discussion (Misc queries) |