Hi All,
I have a spreadsheet that has over a 1000 records. Some of the customer names are repeated because they have visited more than once over the past few years.
I want to delete all of the historic data, just leaving the most recent data for each customer.
I have attached an example spreadsheet, the ones in red are the records I want to delete, which would leave just the most recent records for each customer,
Many thanks
Bookmarks