Sorting by Frequency?

  • Thread starter Thread starter Iriemon
  • Start date Start date
I

Iriemon

Is there any way to sort a list based on frequency?

I have a large spreadsheet that has a alpha code in one column. I would like
to sort the list so that the most frequent entry is at the top.

Any suggestions on how to accomplish a sort other than alphabetically?

Thanks

Irie
 
Hi Irie,

You could use a helper column. Say your alpha code is in column D.
Put this in E1 and drag down as far as is needed,
=COUNTIF(D:D,D1)
Then select all of your data and sort on column E.

HTH
Martin
 
In order for this method to work 100% you should sort on both column E
(in the first hand) and column D (in the second hand).

/ Lars-Åke
 
Works great!

Thanks to both!

Lars-Ã…ke Aspelin said:
In order for this method to work 100% you should sort on both column E
(in the first hand) and column D (in the second hand).

/ Lars-Ã…ke
Click to expand...
 
Back
Top