Sorting by Frequency?

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
 
M

MartinW

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
 
L

Lars-Åke Aspelin

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
 
I

Iriemon

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
 
M

MartinW

You're Welcome Irie, also thanks to Lars-Ake for your input,
good catch!!

Cheers
Martin
 

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

Top