Finding the most common (and 2nd, 3rd most common) text

I have a row of text data. e.g.

Apple Pear Apple Cheese Banana Apple Apple Cheese

I'd like to be able to calculate the most common data occurrence ("Apple"),
2nd most common ("Cheese") and 3rd, etc.

Having done this, I'd then like to count the number of occurences. I do this at the moment, but with a manually identified "leaderboard".

Thanks in advance.

SG

Hi SG

Have you considered using a Pivot Table? Pivot Tables were designed just for this sort of problem :-D