Unique order ID

On the Data Ribbon, there is a Remove Duplicates icon. You could copy the list with duplicate data to another place in your workbook, then use the Remove Duplicated tool.

Please remember, your request is clearer if you attach a sample workbook.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".