Sorting by more than 3 columns

[Jac]

Is there anyway to sort by more than 3 columns in Excel
2002? I keep having to sort by the max 3 columns and
then run a subsort. Has anyone found a trick to all the
sorting at once when you need to sort by more than 3
columns of data?

 

[Bob Umlas]

Must be done in more than one pass -- If you have 8 columns to sort, start
with the 3 LEAST significant and sort, then the 3 Next significant and sort,
then the first 2 significan & sort. The result will be as if you did all of
them with the option to sort 8 columns at a time.
You could also do it with VBA.

Bob Umlas
Excel MVP

 

[Bill]

I've used multiple sort at
http://www.digdb.com/ExcelDig/complexSort/

No affiliation just impressed with products