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



"Iriemon" wrote in message
...
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

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


On Sun, 14 Dec 2008 08:14:37 +1000, "MartinW"
wrote:

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



"Iriemon" wrote in message
...
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

Works great!

Thanks to both!

"Lars-Ã…ke Aspelin" wrote:


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


On Sun, 14 Dec 2008 08:14:37 +1000, "MartinW"
wrote:

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



"Iriemon" wrote in message
...
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

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

Cheers
Martin


"Iriemon" wrote in message
...
Works great!

Thanks to both!

"Lars-Ã…ke Aspelin" wrote:


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


On Sun, 14 Dec 2008 08:14:37 +1000, "MartinW"
wrote:

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



"Iriemon" wrote in message
...
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