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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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.
 
Upvote 0
deleted by Yongle
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

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
Back
Top