J John13 Nov 10, 2006 #1 The sort box gives three, can there be 4 (through an Add-In or something)? Thank you for your consideration. John
The sort box gives three, can there be 4 (through an Add-In or something)? Thank you for your consideration. John
P Pete_UK Nov 10, 2006 #2 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
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 Nov 10, 2006 #3 John13 said: The sort box gives three, can there be 4 (through an Add-In or something)? Thank you for your consideration. John Click to expand... and Excel 2007 will increase the number of sort levels when it's available next year. Bill
John13 said: The sort box gives three, can there be 4 (through an Add-In or something)? Thank you for your consideration. John Click to expand... and Excel 2007 will increase the number of sort levels when it's available next year. Bill
J John13 Nov 13, 2006 #4 Thanks Pete - It worked just the way I needed. And Bill - I'm looking forward to 2007 (heard some neat things.......) John
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 Nov 13, 2006 #5 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 Click to expand...
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 Click to expand...
