Can I sort by 4 Criteria's

[John13]

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

John

 

[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

 

[Bill Sharpe]

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

 

[John13]

Thanks Pete - It worked just the way I needed.

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

John

 

[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