Hi,

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


Thanks in advance.


Haldun Alay

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)
__________________________________________________ __________________________
________________
"Haldun Alay" wrote in message
...
Hi,

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


Thanks in advance.


Haldun Alay

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 wrote:

Hi,

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

Thanks in advance.

Haldun Alay

--

Dave Peterson

It takes time but it works.

thanks

Haldun


"Dave Peterson" , iletide sunu yazdi
...
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 wrote:

Hi,

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

Thanks in advance.

Haldun Alay

--

Dave Peterson