I would insert a new column.

Then fill it with a formula like:
=countif(a:a,a1)
(and drag down as far as I need.)

Then sort the range by this column (primary key, descending) and the original
column (as the secondary key).

Roadtripper902902V3V wrote:

Hello,
How can I sort a column based on repetition.

For example,

Anna
Bob
Bob
Bob
Bob
Chuck
Chuck
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Sam
Sam
Sam

will be:

Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Tiger
Bob
Bob
Bob
Bob
Sam
Sam
Sam
Chuck
Chuck
Anna

--

Dave Peterson