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...
The link doesn't work for me if you could provide a screen of your data, that would be great but based on the general description, you can easily add a column and provide the number reputation of each row and the napply filter, or you can use table.group as mentioned in the above
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.
