I got some fantastic help on this forum yesterday regarding how to count and identify the most frequently occurring words across rows of text.
I now have some added challenges to that same problem that I need some help with.
Attached is a sample Excel 2007 file containing 3 worksheets.
The Raw Data worksheet has the sample raw data. My real data is MUCH larger.
The Stop Words worksheet has a list of words that should not be included in the results. My actual list of Stop Words has about 600 words.
The Count Results worksheet is the final worksheet. In this sheet I'd like to do 2 things. First, I'd like to be able to enter a Maximum number of words to list. So, the user might enter the number 20 (in cell B1), as the Maximum number of words to list.
Second, I'd like to have the sorted list of most frequently occurring words in the Raw Data in one column, and in the next column I'd like to have the frequency with which the words occurred. In other words, the word that occurs most frequently would be listed first, along with the number of times it occurred; however, none of the Stop Words values will be included in this list.
I would really appreciate help with this!
Bookmarks