Get count of unique field values

K

Ken

Hi.

I have a table with a column called Employee ID. Many rows can have
the same Employee ID. I need to get the total number of unique
Empolyee IDs and use this number in a formula.

What's the best way to do this? I'm wondering if I should make a
Pivot table that provides this number, but I'm not sure how to do
that. Or perhaps there is some other approach.

Any info would be greatly appreciated!

Thanks,

Ken
 
P

Peo Sjoblom

One way

=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))

where the employee IDs are in A
 
Top