Let's say I have a column like this:
Dog Bird Cat Dog Dog Dog Bird Cat Bird
It has 4 Dog, 3 Bird and 2 Cat
I want to sort this column descending by these count numbers.
I mean result should be this when I sort it:
Dog Dog Dog Dog Bird Bird Bird Cat Cat
How can I do that in Excel 2007?