delete oldest duplicates

helenmeyer

New Member
Joined
Mar 3, 2014
Messages
23
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:

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,765
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,977
Office Version
  1. 365
Platform
  1. Windows
deleted by Yongle
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,596
Messages
5,832,638
Members
430,149
Latest member
amitk1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top