This is VERY resource intensive, so be careful using it on a list of several
thousand entries

It's an array formula - enter it with the key combination Ctrl+Shift+Enter

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



"Rob Kaiser" wrote:

I am looking for a command/formulat to count (return a single number) the
number of unique text entries in a column.