![]() |
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