The solution depends upon the organization of your data. For example, if you
have a single column of single words like:

Words
cat
dog
dog
fish
cat
dog
fish
fish
cat
dog
fish
fish
dog
dog
dog
cat
cat
dog
fish
cat
fish
dog
dog
dog
dog

Then a Pivot Table can give the count of each unique enter:

Count of Words
Words Total
cat 6
dog 12
fish 7
Grand Total 25

If your words are in paragraphs within cells, then a different approach
would be taken.

--
Gary''s Student - gsnu2007e


"LAN MIND" wrote:

Hello all,

I am trying to optimize my database. I need to find the top occurring
words on my excel file.

Is there any freeware or add-ons that can perform word frequency
counting on excel files?

Thanks for any help- Lan