MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sort by more than 3 keys


Posted by Darin Wilmert on October 14, 2001 10:21 AM

Hi, I want to sort my sheet, and I go to DATA->SORT, but it only lists 3 possible options to sort by. I need to sort by about 24 columns.
In other words, it lets me do :

Sort by Column h
then by Column g
then by Column f

But I need it to do about 24 of those. How can this be done?
Thanks.


Posted by J Hamnett on October 14, 2001 12:06 PM

Add the columns together that you want to sort. For example, say you want to sort columns A, B, C and D starting in row 3. In column X enter +A3&B3&C3&D3. Copy this formula down to all the rows you want to sort. Then use column X to sort. Make sure you have the right order in your columns and all the columns get sorted the same way (asending or desending).

Posted by Aladin Akyurek on October 14, 2001 12:24 PM

Also see 'sorting.zip' at http://geocities.com/aaronblood/ (NT)