How to sort a sheet with more than three criteria

[Haldun Alay]

Hi,

is there any way to sort a sheet with more than three criteria.


Thanks in advance.


Haldun Alay

 

[Mike]

One way to do it is by creating a new column that holds a combination of
some of your criteria, though this may not work for all examples, but if you
wanted to sort by gender / age / last name / first name, you would make a
new column that is last name & " " & first name, and sort using that column.

hth.

--

____________________________________________________________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)
____________________________________________________________________________
________________

 

[Dave Peterson]

You can sort multiple times.

If you have to sort by 15 things, sort by 13-15, then 10-12, ..., then 1-3.

(I always screw it up the first time and sort by the wrong keys first, but then
I just do it again.)

 

[Haldun Alay]

It takes time but it works.

thanks

Haldun

You can sort multiple times.

If you have to sort by 15 things, sort by 13-15, then 10-12, ..., then 1-3.

(I always screw it up the first time and sort by the wrong keys first, but then
I just do it again.)