Assume your range is A1:A10:

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

--
Regards,
Dave


"shzdug" wrote:

Is there a function, or good way,to count unique text in a list? For
example, I would like an answer of 3 from the text in the list below:

Dog
Cat
Dog
Bird

Thanks!