Thanks very much!
I tried it with a test sample of movie titles. I used same range in formula and these sample cells repeated until I filled out the full A1:A100 range.
When I enter the formula, in a cell outside of column A, I see that the whole range of a1:a100 highlighted.
These 13 cells are repeated until a100
Straight Outta Compton |
Spare Parts |
Room |
Trumbo |
The Martian |
Spotlight |
Self/less |
Child 44 |
Steve Jobs |
Dark Places |
Irrational Man |
Uncanny |
The Creed |
<tbody>
</tbody>
When I enter the formula using CTRL SHFT ENTER - it does put correct brackets around formula but the formula returns only the 1st entry of "Straight Outta Compton"??
What I am looking to do is output the most frequent words along with the count of the words and it would be great if I could output common phrases and counts - i.e., "hit the refresh button" may appear 500 times in my narrative field - I'd like to see the actual phrase outputted along with a count. Maybe something like outputting the most common word and counts and then most common 2 words and count, etc. Or most common few words that appear in order within a cell and the count.
I need to be able to look for a pattern of issues our customers may be reporting based on the text entered by our agents (free form) - given the above type of formula - I can quickly get a read on what customers are complaining about the most within a higher level category we have for our trouble tickets. For example, I can filter the data by customer education questions but would need a good formula to pull out the most common questions.
Sorry for the long reply - appreciate you help!
John