Counting words

[Jeff]

Hi

I have a column with different words for a budget like car, tv, etc.
There are a lot of them and in some cases there are repeats.
Is there any way to count the number of unique words, without counting
repeated words?

Thanks a lot for you help.

 

[Frank Kabel]

Hi
use
=SUMPRODUCT((A1:A20<>"")/(COUNTIF(A1:A20,A1:A20)+(A1:A20= "")))