Get count of unique field values

  • Thread starter Thread starter Ken
  • Start date Start date
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
 
One way

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

where the employee IDs are in A
 
Back
Top