There is a relatively quick and painless solution.
Assuming your data is sorted by Order number and then by Date
Put this formula in a the cell coresponding to your first row of data, but within a new column.
=IF(OrderNumberCell1=OrderNumberCell2,0,1)
Change OrderNumberCell1 and OrderNumberCell2 to appropriately to match your table of course.
Drag the cell to replicate it throughout the column, and you will have a column of ones and zeros, ones being rows you want to keep.
Turn on the Autofilter and use it select just those rows with ones in your new column and Roberts your Mother's Brother.