I was hoping this could be done without using VBA. If VBA is the only way I can figure that out.

I have a spreadsheet that among other things has a list of text words and phrases. I would like to create a new list that lists all the unique words used in the original list with a 2nd col that shows how often that word is used and have it sorted by highest to lowest. If I have the list below

1. red widgets
2. blue widgets
3. red widgets that glow
4. buy widgets
6. blue and red widget repair (you count the blue and red in this)

This would give



widgets 4
red 3
blue 2
buy 1
repair 1
widget 1
glow 1
and 1
that 1