Number of unique words in a column

Hello all,

this is very similar to my last question. I am needing a way to count each unique word in a column. Each cell in the column contains a comma separated list (mostly one worded but there are some that are 2 words)

Word Count Sample.xlsx

thanks

well if you can copy the whole column then you can Macguyver it:
Copy the entire column,
Paste into Notepad to get rid of the formatting,
Copy paste into a word document,
Go to Edit>Replace>
Find: " , " Replace with "Paragraph mark" (If you can't find the paragraph mark its in the replace dropdown. You may need to select "more" or options where there should be a "Special drop down" and "Paragraph Mark is the first one
Hit Replace all.
In a new sheet in your workbook paste the words from the Word Document (now on top of one another)
Select all, and go to Filter>Advanced> and check the "Unique Values only" box. That'll take out the doubles, and if you just delete all rows and starts at 1 you'll have your total. If you want to know how to use the COUNTIF function lemme know

Well...whatever. One you have all your text in cells one on top of one another use this (replace your own range instead of A1:A10)

=SUM(IF(FREQUENCY(IF(LEN(A1:A10)>0,MATCH(A1:A10,A1:A10,0),""), IF(LEN(A1:A10)>0,MATCH(A1:A10,A1:A10,0),""))>0,1))

don't forget Crl+Shft+Entr and not enter

Yes it is a once off. that worked and was simple enough.

thanks