sort with 4 parameters

H

Hal

Hi,

Current data sort allows for 3 parameters to sort with. Is there a way to
sort with 4 or more paramters.

Thanks!
Hal
 
C

carlo

Hi Hal

Make a hidden column, where you concatenate 2 or more columns, and
then sort after this one, should do the trick.

Cheers Carlo
 
R

RagDyer

All you have to do is sort twice.

Start off in reverse, with the *least* important parameter first, and work
your way up in significance.

You can do 3, then 1,
OR
2 and 2,
OR
1 and 3.

You can sort with as many criteria as you need.
You're just restricted to doing it a max of 3 at a time!
 
Top