Hi,
I have a spreadsheet of data, sorted by columns A, D and E with E sorted newest to oldest.
I then want to check columns A to D for duplicates and for any duplicates found I want to delete the complete row that has the oldest date in column E. In the example above I want to keep all rows highlighted in green and delete the rows in yellow.
I've tried concatenating columns A to D and then deleting the oldest row based on the date in column E however it just deletes the oldest duplicate date in columns A to E and leaves everything in columns F to I so if I started with 100 rows I end up with 50 rows in columns A to E and 100 rows still left in the adjacent cells.
Hopefully someone is able to help.
Thanks.
I have a spreadsheet of data, sorted by columns A, D and E with E sorted newest to oldest.
I then want to check columns A to D for duplicates and for any duplicates found I want to delete the complete row that has the oldest date in column E. In the example above I want to keep all rows highlighted in green and delete the rows in yellow.
I've tried concatenating columns A to D and then deleting the oldest row based on the date in column E however it just deletes the oldest duplicate date in columns A to E and leaves everything in columns F to I so if I started with 100 rows I end up with 50 rows in columns A to E and 100 rows still left in the adjacent cells.
Hopefully someone is able to help.
Thanks.