Dear Dave

Assuming your data is in Col A use the below formula

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

If this post helps click Yes
---------------
Jacob Skaria


"NaplesDave" wrote:

I need to be able to count the number of times an item Uniquely appears in a
column. IE:
Result cell NAMED: Species
Contents of column:
CAT
CAT
DOG
CAT
FISH
FISH

Species should = 3

How can I do this function in EXCEL 2003?