count...how?

[Rick]

In Excel 2000 I would like to count the unique entries in
a range of data. Any ideas?

 

[Jason Morin]

One way:

=SUM(1/COUNTIF(A1:A10,A1:A10))

Array-entered.

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

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

or if there can be empty cells involved

=SUM(IF(LEN(A1:A10)>0,1/COUNTIF(A1:A10,A1:A10)))

entered with ctrl + shift & enter

 

[Harlan Grove]

...
...

or if there can be empty cells involved

=SUM(IF(LEN(A1:A10)>0,1/COUNTIF(A1:A10,A1:A10)))

entered with ctrl + shift & enter

...

Picky: array-entry unnecessary.

=SUMPRODUCT((A1:A10<>"")/(COUNTIF(A1:A10,A1:A10)+(A1:A10="")))

Less picky: A1:A10<>"" is likely more efficient than LEN(A1:A10)>0.