I have a column of data in the form
a
a
a
b
b
c
c
etc.,
I know I can run an Advanced unique filter to obtain a list of unique
values and then use a COUNTA function to count them, but is there a
single function that would return the result, i.e. 3 (a, b & c) given
the above data?
(apologies if this appears twice - I thought I had posted it directly
to the GoogleNews (Deja) site but it doesn't seem to have turned up.
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Bookmarks