Hi, i've looked all over google but i can't solve this:

I have a list with independent text strings that are randomly repeated, and i want to sort them from the most common to least.

For Example:

Column A
---------
Dogs
Cats
Elephants
Dogs
Dogs
Cats
...

What i would like to get is (from the column above):
Dogs (with 3 ocurrences)
Cats (with 2 ocurrences)
Elephants (with 1 occurence)

I don't want to do it manually, i.e. having to type "Dogs" or "Cats" anywhere; i just a formula that looks at the whole list and determine which is the most common, which is second most common and so on...

I found something that finds only the most common, perhaps that's a start:

Most Common String In A Range
=INDEX(Rng,MATCH(MAX(COUNTIF(Rng,Rng)),COUNTIF(Rng,Rng),0))

(where "Rng" is the range, in this case Column A)

Is there any way to tweak that, so it sorts the list by number of ocurrences?

thanks in advance,
T.Balza
tomas {D0T} balza {AT} gmail {D0T} com