Sorting a 30000 line spreadsheet

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?

This is not an Excel forum, if you need help on how to do this in R, please provide a proper REPRoducible EXample (reprex) illustrating your issue.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.