Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting the occurrence of specific text within a date range | Excel Worksheet Functions | |||
How do I highlight a single word or group of words? | Excel Discussion (Misc queries) | |||
How can I hide the words of a cell (or a group of cells)... | New Users to Excel | |||
counting specific words | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions |