Kansara Mahendra asked:-
Can you please guide me if there is way in EXCEL 97 to sort
selected lines and columns with more then only 3 default criterias ?
I believe the trick is to do it in two parts. If you have 5 criteria to sort
by then first sort by the 2 least important criteria, then sort again by
the 3 most important.
Imaginary example.
Sort wanted on.
job - code - town - name - age
First sort by
name - age
then sort by
job - code - town
Regards
Tony
Tony Beckett - Rutland, UK
Curious about the people moderating your
messages? Visit our staff web site:
http://freepctech.com/staff.shtml
|