MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sorting 2 rows

Posted by Alan on January 17, 2002 9:32 AM

i have a few hundred rows of records in 8 columns. For display purposes i need to have the data in only 4 columns and 2 rows (and a new record would be every other row) but this meeses up my sorting ability. How can I sort data now that it's not all in the same row?

Posted by paul on January 17, 2002 10:16 AM

don't know but what I tend to do with "tricky" sorting needs is that I add an additional column (you may hide it for others) inwhich I add a sequential number or any other data element (1 unique per record) which provides for an additional sorting argument. You can add multiple if you like; but I am still puzzled how you want to sort when each of your original columns will only have one label at the top...?