Sort according to most repeated entries

  • Thread starter Thread starter Roadtripper902902V3V
  • Start date Start date
R

Roadtripper902902V3V

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
 
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).
 
Thanks, Dave. Your "countif" formula worked.
It didn't seem necessary to do the "secondary key" sorting. All I did after
the getting the "countif" formula from top to bottom was just "sort" this new
column of countif values by largest to smallest.
Am I missing something?

Thanks.
 
If there are entries that show up with the same count, you may find those
entries mixed up.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

4 alternatives to all questions need randomization 1
How to keep track of node levels when we Linq an XML document? 1
Formula to return desired Result 4
How Do I? Perform simplae Average on a indexed text location 9
Explicit specification of range variable required when hiding inherited IEnumerable<T> 5
Epson Smart Panel 3.5 Mac for Epson perfection 1250 0
Moving to Windows from a Mac 4
Tough: Vlookup, Match, Sumproduct? To create list of persistence 1

Back
Top