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...
Before (data is unsorted) highlighted number are repetetive need number in A column with latest date in M column.
After
I agree with Omid_Motamedise. Either of our proposed solutions will work on that data.