I have a worksheet full of data, across which I'd like to gauge what words + 3 words on either side appear most frequently in that set of data.
To begin, I'd like to see what words appear most commonly in this data. And then to search for some of those words + 3 words on either side them.
So my first question is how to find what words appear most often in this data, most to least frequently.
Then how to search for say, word X + 3 words on either side of that word X.
I know the stars here at Mr Excel can figure anything out, so I thank you in advance: Thank you!! <3
___________________________________________________________________________________
There used to be a post here like this, with a file attached demonstrating this. The post was called, below, but is no longer in existence at its link.
Finding most common words in column WITHOUT specifying what words
To begin, I'd like to see what words appear most commonly in this data. And then to search for some of those words + 3 words on either side them.
So my first question is how to find what words appear most often in this data, most to least frequently.
Then how to search for say, word X + 3 words on either side of that word X.
I know the stars here at Mr Excel can figure anything out, so I thank you in advance: Thank you!! <3
___________________________________________________________________________________
There used to be a post here like this, with a file attached demonstrating this. The post was called, below, but is no longer in existence at its link.
Finding most common words in column WITHOUT specifying what words
Last edited: