Forum Discussion
Filter duplicate rows with latest date
I have a data table as shown in the sample file Sheet1 (before) I need the output as shown in Sheet2 (after) The data is not sorted. I need to exclude duplicate rows using latest date as criteri...
There are several numbers with their respective dates so I can't select a date manually
Nowhere in my code am I selecting your date manually. You merely need to know the name of the column that contains the dates and the columns that you wish to check for possible duplications.
The table group function will select the appropriate date.
- The process I listed is merely what the code does.