count unique phrases in a word table or spreadsheet

G

Guest

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?
 
D

Domenic

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

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

Adjust the range accordingly.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting 3
countif where condition should be met 3
Count rows based on multiple criteria 3
Replace Part of a Function 2
Count how many times a phrase comes up? 3
Counting and deleting 7
Count values, excluding duplicates and specific values 2
Counting repeating cell values 2

Top