Hello all,

Not sure if this is possible to do, but thought I would inquire. I have a large file (about 900 entries) with customers' first and last names and a history of ALL the orders that they have placed with us (Each unique order is an entry in the file). I want to filter the list down so that we have only one entry for the customer: their most RECENT order with us. Is there some function or formula I can use to do this? The only thing I can think to do is eyeball each customer and manually figure out which entry is their most recent order.