We're trying to sort a spreadsheet of data with entries collected from subjects every 6 months. We now want to delete duplicate lines and leave the most recent entries by latest date. How can we write a macro in Excel to delete duplicate lines to only leave the most recent date entries?