Word List and Count from a string

I'm about to go crazy figuring this out and was hoping someone might be able to help with my situation.

I want to take a string which is a list of words and compile a list of the words listed and how many times each one is listed.

For Example, for the string "word1, word2 word1, word3 word2"

I want to get the following calculations:

word1 = 2
word2 = 2
word3 = 1

Thanks for everyone's help.

g

Supposing A1:A10 is range of strings.
C1:C3 is Word1, Word2 and Word3 respectively.
D1

Please Login or Register  to view this content.

Copy down.

Hope this helps.

Originally Posted by snasui

Supposing A1:A10 is range of strings.
C1:C3 is Word1, Word2 and Word3 respectively.
D1

Please Login or Register  to view this content.

Thanks for everyone's help. This worked great to calculate the number of times the word repeated.

Now how can I have the word list built dynamically form the string? In other words, I want a list containing each word the appears on the string, but I want it to be listed only once?

Thanks,

g

How do you make this thread as solved?