I want to parse words and get a count
Situation: I have open ended survey answers. I want to create blog content to address the most highly mentioned concerns. I need to go through the answers and find any word (i.e., I don't have any particular words in mind) and then get a count of the number of times that word occurs. (I expect I'll get the word 'the' 10 million times!)
If I can get one column to show me the word, and the second column to show me the Count, I can sort by count and get the info I'm looking for.
All of the survey answers are in one column. There are 39k rows, though I can reduce that to a statistically significant number. Maybe 500 rows?
Help Article Resources
Check out the Formula Handbook template!