Counting Unique values in Excel column 1

[smooveb]

Hi!

I feel silly even asking this. How do I get a count of unique values in an excel column?? (easiest way?)

B

 

[xlhelp]

Data, Filter, Advanced Filter, Unique Values.



Member AAA - Abolish Abused Abbreviations

 

[firefytr]

Also check out the UNIQUEVALUES formula in the morefunc.xll addin by Laurent Longre ...

http://xcell05.free.fr/english/

There are many other ways with worksheet formula, but the morefunc and what xlhelp posted are the easiest (IMHO).

-----------
Regards,
Zack Barresse

 

[byundt]

Here is a link to the worksheet formulas that Zach doesn't like:

http://www.cpearson.com/excel/duplicat.htm#CountingUnique

If your data doesn't contain any blanks, then you can use:

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

Brad