Data sorting in Excel 2000

J

Jon

I know Excel can data sort on up to 3 columns...I have a
spreadsheet that requires 88 sorts! Can this be done, if
so how?!
 
F

Frank Kabel

Hi
just start with the least relevant three columns and repeat this over
and over again (Though I wonder why anybode wants to sort based on 88
different columns?)
 
D

Debra Dalgleish

There are instructions here for sorting more than three columns:
http://www.contextures.com/xlSort01.html#Sort04

If this is something you do frequently, you can record a macro as you
sort the list, then run the macro the next time you need to sort.

You can name the range that contains the list:
http://www.contextures.com/xlNames01.html

Then use that name in the macro, e.g.:

'==============
Sub SortList()
Range("Database").Sort Key1:=Range("H2"), _
Order1:=xlAscending, Key2:=Range("G2"), _
Order2:=xlAscending, Key3:=Range("F2"), _
Order3:=xlAscending, Header:=xlGuess
Range("Database").Sort Key1:=Range("B2"), _
Order1:=xlAscending, Key2:=Range("C2"), _
Order2:=xlAscending, Key3:=Range("A2"), _
Order3:=xlAscending
End Sub
'=====================
 
Top