Sorting by Frequency?
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
|