ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   counting occurrence of specific words in another group of words (https://www.excelbanter.com/excel-programming/369459-counting-occurrence-specific-words-another-group-words.html)

[email protected]

counting occurrence of specific words in another group of words
 
Let's say I have several cells, each containing a short string of
words. Some cells have a string of 2 words, some 3, some 4, etc. I
also have a group of paragraphs, with each paragraph contained in its
own cell.

I would like to know which paragraph has the highest occurence of the
words in the short strings. In other words, if Cell A has "bat, rat,
cat" I'd like to know in which of the paragraphs those three words
appear most often.

Before I reinvented the wheel, I figured there might be something
already out there that does this and thought I'd ask around. Has
anybody seen something like this or know of a few components I might
string together?

Thanks in advance for any pointers.



All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com