Sort more than 3 columns

[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-

 

[Bob Phillips]

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)

 

[Pete_UK]

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