Unique records in pivot table - formula?

P

PsyberFox

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!
 
Top