Count number of Unique values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A belated Happy New Year to All

Wondering if it is possible to count the number of unique values in a column
???

A column contains 5 digit numeric values and I am looking for a method that
will tell me how many different values are in the column.

ie 23456 34567 56789 23456 56789 = 3 ??

Any help appreciated

Thanks
 
Hi Alan

use the following ARRAY formula (enter with control & shift & enter, not
just enter)

=SUM(1/COUNTIF(A1:A10,A1:A10))

Cheers
JulieD
 
Hmm - this (and the sumproduct one) seem to crap out with any blank cells in
the range. Here's the one that works:

=SUMPRODUCT((D1:D100<>"")/COUNTIF(D1:D100,D1:D100&""))fromhttp://groups-beta
..google.com/group/microsoft.public.excel.worksheet.functions/msg/d5e376baefe
8898c
 
Back
Top