Sorting

  • Thread starter Thread starter Darin
  • Start date Start date
D

Darin

Is there a way to sort more then 3 columns or have more then 3 criteria to
sort on? I currently have 7 and usually I just parse the data but would
prefer to simply sort on the original set, thx.
 
Not directly. Per "Excel limits & specifications"
"Sort references: 3 in a single sort; unlimited when using sequential sorts "

However, you could record a macro of your sort (sequentially) and make this
a custom button on a toolbar, if you want.
 
Sort them 3 at a time, sorting by the least significant group first.

If you have 7 columns A to G in decreasing order of significance, select the
whole range then for your first sort, choose sort by E then F then G.
Then sort again by B then C then D.
Then sort again just by A.
Just make sure that in each case you have the whole range selected before
you sort.
 
Back
Top