Sort column by amount of same content cells

  • Thread starter Thread starter Mike M
  • Start date Start date
M

Mike M

I got data in column A, B C and D

I need to sort by column A based on the quantity of cells with same content.

I got this:

banana
banana
boat
tape
banana
boat

I need it sorted like this:
banana
banana
banana
boat
boat
tape

Is that possible?

Regards
Mike
 
Use column E as a helper column, with a formula like:

=COUNTIF(A$1:A$100,A1)

This assumes you have 100 rows of data - adjust to suit and copy this
down.

Then you can sort the range A1:E100, using column E as the sort key.
Afterwards, you can delete column E.

Hope this helps.

Pete
 
Back
Top