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

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.

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

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

"cbruton1975" wrote:

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.

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

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sloth" wrote in message
...
=SUMPRODUCT(1/COUNTIF(A1:A600,A1:A600))

"cbruton1975" wrote:

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.