Assuming that Column A contains your data, try...

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

Adjust the range accordingly.

Hope this helps!

In article ,
SDB wrote:

I need a macro or function to count the number of unique phrases in a word
table or spreadsheet. I have tried using several different COUNTIF functions
but I keep getting the same errors each time. Any suggestions?