I have a worksheet with data in columns A thru I and a total of 5859 rows. The data in column F should be unique but there are duplicates that I need to remove based on the value in column H. Column F is a alpha numeric serial number and column H is a date. If there are 10 duplicates (ten rows with same serial number in column F) then I want to remove the rows with the oldest date and keep the row with the newest (most recent) date. Please help
Bookmarks