delete oldest duplicates

helenmeyer

New Member
Joined
Mar 3, 2014
Messages
17
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?
 
Last edited:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,707
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

Well-known Member
Joined
Mar 11, 2015
Messages
6,707
Office Version
  1. 365
Platform
  1. Windows
deleted by Yongle
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,626
Messages
5,523,982
Members
409,550
Latest member
baaabies

This Week's Hot Topics

Top