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