Sorting by more than 3 columns

  • Thread starter Thread starter Jac
  • Start date Start date
J

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?
 
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
 
Back
Top