I'm working in Excel 2007. I have a table in which a particular column will have duplicates; I need to report one of the rows with the duplicates but the row that remains must be determined by a date in another column.
See the attachment. The first row should remain because there is no duplicate in the EPD_IDENTIFIER column. The next two rows have a duplicate in the EPD_IDENTIFIER column but I need only the row with the latest time stamp in the EPD_STATUS_CHANGE_TS column to remain. All the rows with a red arrow should remain, the other deleted.