Nested Sorting (Sorting by one variable while already sorted by another variable)

[ccb12]

I have a spreadsheet that lists different operations performed on a work order. Each operation is a different row and the column headers are "Order", "Operation", "Start Date", and "Finish Date". Each order could have as many as 10 rows associated with it. The start times of operations within an order will be sequential but start times of operations of different orders will not be sequential. I would like to sort the rows by order to keep each orders operations grouped together. I would also like to sort the operations within an order by the start date of the operation. So basically, how can I perform nested sorting?

[Glenn Kennedy]

Please attach a sample workbook - and not a picture of one. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

However, nothing on this Forum works quite as well as you might expect. The attachment icon doesn't work!! (Helpful, isn't it!!). Instead, just before you submit your post, click on GO ADVANCED (near the bottom) and then scroll down to Manage Attachments to open the upload window. The relevant instructions are at the top of that screen.