One way

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


Regards,

Peo Sjoblom

"Rob Kaiser" <Rob wrote in message
...
I am looking for a command/formulat to count (return a single number) the
number of unique text entries in a column.