Try something like

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

reference:
http://www.pcmag.com/article2/0,1759,1537551,00.asp


"Alan" wrote in message
...
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