Hi Alan

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

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

Cheers
JulieD


"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