removing duplicates and oldest date

[chubbster31]

Hello,

What I am trying to do is use a VBA code to remove duplicates of a column of data as well as the oldest date. See the pictures below.

dates 1.PNG

The picture above shows a column of dates, they are not necessarily in any order but in this case they happen to be. In a different sheet, I want the duplicates removed and the oldest date. The picture below shows the desired result, with this result preferably being in date order and the date values of "31 March 2016" being removed completely because that is the oldest date.

dates 2.PNG

On top of this, I am trying to have the code so that if more dates get added to the first list, they will automatically be added to the results column if I run the code.

I'm sorry if this is complicated because it's quite specific, but I don't know how to do it so any help would be great

Thanks

[kalbasiatka]

Please Login or Register  to view this content.

[stnkynts]

If data in column A this will put your output in column B

Please Login or Register  to view this content.

[chubbster31]

thank you

at the moment it deletes the most recent date. How can I alter the code to get it to delete the oldest date?

[jindon]

Alter a1 to suite

Please Login or Register  to view this content.

[chubbster31]

Thank you, that worked great

[jindon]

You are welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.