Can I sort by 4 Criteria's

J

John13

The sort box gives three, can there be 4 (through an Add-In or
something)? Thank you for your consideration.

John
 
P

Pete_UK

Highlight the sort range and sort by your lowest three criteria. Then
sort again choosing your highest (main) criteria.

Alternatively, you can join two or more fields together in a temporary
column, and include this in your sort range as one of the sort fields.

Hope this helps.

Pete
 
B

Bill Sharpe

John13 said:
The sort box gives three, can there be 4 (through an Add-In or
something)? Thank you for your consideration.

John
and Excel 2007 will increase the number of sort levels when it's
available next year.

Bill
 
J

John13

Thanks Pete - It worked just the way I needed.

And Bill - I'm looking forward to 2007 (heard some neat things.......)

John
 
P

Pete_UK

Thanks for the feedback, John.

Pete
Thanks Pete - It worked just the way I needed.

And Bill - I'm looking forward to 2007 (heard some neat things.......)

John
 
Top