Hi Richard,

Try...

=SUMPRODUCT((YourRange<"")/COUNTIF(YourRange,YourRange&""))




"Richard" wrote in message
oups.com...
I have a list of values down a column, e.g.

a
a
a
c
c
e
e

etc.

I know I can use advanced filter to get a list of unique values and
then count them, but is there a single function that would achieve
this.

i.e the result for the data above would be 3 (a,c & e)

Rgds