Count Unique Values

[Douglas]

Dear Folks,

Using Excel 97---

I wish to count unique values in a list of values.....any ideas?

 

[Jason Morin]

There are a few methods. Here's one (assuming no blanks in
the data):

=SUM(1/COUNTIF(rng,rng))

Enter it with ctrl-shift-enter.

HTH
Jason
Atlanta, GA

 

[Douglas]

Thanks...

Saw a suggestion in the Knowledge base to use
FREQUENCY, as well

=SUM(IF(FREQUENCY($B$2:$B$58,$B$2:$B$58)>0,1))