Clear Duplicates

Hey everyone this is my first post on any excel forums. I can usually find a solution just by browsing but not this time. What i'm trying to do sounds simple enough. I have 2 Columns of data, example;

1-Apr 1423
1-Apr 1426
24-Apr 1430
8-May 1454
8-May 1460
15-May 1500
15-Jun 1525
15-Jun 1555
15-Jun 1556

I want to clear (not delete) the cells with a duplicate date in them while keeping the cell with the number next to it. So in this case they would be A2, A5, A8, A9. I've come up with a code that looks pretty logical but it doesn't work. Here's what it looks like.

Please Login or Register  to view this content.

Nothing much happens when i run this, it goes to the empty cell under the last used cell and doesn't clear anything.

TIA

-Chris

--Edited a few bits of the code.

Welcome to the forum.

Try this:

Please Login or Register  to view this content.