Function in Sequel to perform a similiar function in excel

I have multiple records in a view.    What is needed is only record per order number.   Each order number goes into multiple sales orders.   They want to see only one record per order and the sales information of the earliest order. In Excel you sort it by order number and sales due date.  Then you run remove duplicates and it leaves the first one it comes to and deletes the rest.  Is there an easy way in Sequel to do this also?

yes.  build the view as needed.  set the sort on the order ascending and the date in descending order.  select file/properties and set the unique key to 1.