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?
sum values
and change it tocount
and then drag the header torow labels
it will make the table, then change the sorting options. It may not be exactly what you want