Ignoring common word

i have a word document . i have to use excel to open the document and then print the frequency of each word in the document . But the problem is we do not have to print the freqency of some common words like 'if', 'that' ','the' etc. These words on the ignore list will be entered by the user in another sheet or maybe an input box. Let say that the maximum words on ignore list is 20 . then how do we print the frequency of each word in the word document leaving the words on the ignore list,ie common words like 'if', 'that' ','the' are not reflected on the excel sheet? What is the command needed?

thanx

It kind of depends on how you build your word list.

A way, I guess, would be to read each word from the Word doc, and do an insertion sort into the list of words read so far, and if already present, bump its histogram. If you had a list of common words as a named range, then you could test against this list (using Match or Find) before inserting the new word.

Hi

I've assumed that your list of common words is on sheet2!A:A and you are currently on any other sheet in the workbook.

Please Login or Register  to view this content.

rylo

A scripting dictionary is a very nice approach, rylo.