delete oldest duplicates

[helenmeyer]

Hi All

Is there a way to delete duplicate values BUT only the oldest duplicate lines?

I have attached a worksheet similar to the one I am wanting to use . I would like delete all but the latest date IPO's - duplicate values in column B with the latest date from column C. Hope that all made sense

For some reason I cant attach to this question?

 

[SpillerBD]

The "Remove Duplicates" feature found under the data Ribbon keeps the first instance found. This is based on the current order, so you can re-order/re-sort the Table so Oldest are first and then use the Remove Duplicates.

If there is specific sort order that must be maintained, it may be necessary to add another column to add an index that the data can be resorted to after removing the duplicates.

 

[Yongle]

deleted by Yongle