Identify duplicate rows and delete all but the most recent

Good afternoon
I’d like to introduce myself, recently retired from the military and working on a job conducting analysis of business process. Pretty good at excel but a novice at using VBA. I have a large spreadsheet with over 700 rows. I would like to identify all the duplicate rows using column “account number” and then use the “date completed” column to identify the most recent row and delete all older duplicate rows. I have used conditional formatting to identify the dups but don’t know how to sort their rows by date and delete the older ones. Think my answer is to use VBA but I haven’t done something this complex. Really could use someone’s help. I have attached a small sample of the spreadsheet I’m working with. Thanks

If sorting Column C is ok then try the macro below on a copy of your sheet.

Please Login or Register  to view this content.

Sorry but your post is really confusing me as what you are stating is almost the exact opposite of what the macro actually does. Consider the attachments below.
TEST1 is the original data, TEST2 is the result after the macro is run.

Now if I wanted the most recent duplicate in Column E using the dates in Column C I would expect the result to be

A 03/01/2012 AAA
A 06/01/2012 BBB
A 09/01/2012 CCCC

This is what the macro gives me (my dates are in dd/mm/yyyyy but that doesn't make any difference as long as the dates are true dates)

Please can you explain what answer you require from the data in TEST1 that is different to TEST2?????

Happy you got it to work. You should also consider AB33's code as it doesn't involve sorting the column

Edit: posted at roughly the same time as the OP's response