Hello all,
Lets assume that i have this table for example:
A -- B -- C
======================
Dog -- 18/11/06 -- White
Cat -- 09/08/10 -- White
Bird -- 23/12/06 -- Yellow
Dog -- 20/01/00 -- Brown
Dog -- 20/05/99 -- Black
Fish -- 18/12/09 -- Blue
Cat -- 30/02/07 -- Brown
Bird -- 01/03/03 -- White
Dog -- 06/06/74 -- Black
Bird -- 17/10/05 -- Orange
I want to use Excel to count the values in column A (Animal type) and then sort the entire table by the most frequent value (if "Dog" appears 4 times, it'll be the first, then "Bird" - 3 times, and so on).
The wanted outcome is this:
A -- B -- C
======================
Dog -- 18/11/06 -- White
Dog -- 20/01/00 -- Brown
Dog -- 20/05/99 -- Black
Dog -- 06/06/74 -- Black
Bird -- 23/12/06 -- Yellow
Bird -- 01/03/03 -- White
Bird -- 17/10/05 -- Orange
Cat -- 09/08/10 -- White
Cat -- 30/02/07 -- Brown
Fish -- 18/12/09 -- Blue
How do i do that?
Thanks,
Kazabu
Bookmarks