View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kh@horsemanship101.com is offline
external usenet poster
 
Posts: 1
Default 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.