How can I count up values in a list that includes duplicates?

C

cbruton1975

I have a list of values, some of which are duplicated (around 600 rows). I
would like to know how many unique values there are in the list, using a
formula.
 
R

RagDyer

And if the list contained any empty cells, you'd need something like this:

=SUMPRODUCT((A1:A600<>"")/COUNTIF(A1:A600,A1:A600&""))
 
Top