Sort Data by Frequency

G

Guest

Is it possible to sort data by the frequency in which a number occurs instead
of ascending/descening? Currently I sort by a column which is currency so
that items of the same $ amt are together. I would like to have the items
that occur the most be at the top with those that occur only once at the
bottom.
 
M

Myrna Larson

Let's say your data is in A1:L289, with headers in row 1 and the amount in
question in column K. In M2 put this formula =COUNTIF($K$2:$K$289,K2) and copy
it down. Then sort with 2 keys: the first is column M, the 2nd key is column
K.


On Thu, 24 Mar 2005 19:53:02 -0800, "Susan Smith" <Susan
 

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

Similar Threads

Can an Excel Spreadsheet automatically sort new data? 2
Sorting by Frequency? 4
Drop Down Sort Button. 2
Function '=Frequency' Help! 3
Sorting day names chronologically 5
Sorting by date and ASAP 3
frequency a number repeats in a column 5
Sorting and Blank Cells 1

Top