Sort more than 3 columns

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Can anyone advise if and how it is possible to sort more than 3 columns.

The Data-Sort menu option only allows you to sort by 3, but I need to
sort by 5 columns.

Any help greatly appreciated.

-Jay-
 
Sort by the minor 3 first, then the again by the major 2.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
This link explains how to do this:

http://www.contextures.com/xlSort01.html

Basically you sort on the least important items first, then sort on the
others.

Alternatively, you can combine a number of the fields together in a
helper column and use that as one of your sort fields.

Hope this helps.

Pete
 
Back
Top