How to sort a sheet with more than three criteria

  • Thread starter Thread starter Haldun Alay
  • Start date Start date
H

Haldun Alay

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)
____________________________________________________________________________
________________
 
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.)
 
It takes time but it works.

thanks

Haldun


iletide sunu yazdi said:
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.)
Click to expand...
 
Back
Top