count unique text values

[Luminary Xion]

How do I count unique text values in a column?

In the attached example; I want A6 to be a formula that counts A1;A5 and finds three unique values.

Thanks!

[Leith Ross]

Hello Luminary Xion,

Here is a formula you can use to get the number of unique values in a column...

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

Sincerely,
Leith Ross

[Luminary Xion]

That helps, but what if I don't want to include numeric values? only Text values?