De-duplicating data based on reference & pay amount removing the earliest row

[LittlegmoonBH]

Hi Guys,

Let me set the scene.

I have a transactional database that creates duplicates… Theduplicates will have a matching reference, they may have a matching paymentamount but they will have different dates.

I have the data in Excel format.

I need to remove all duplicates where the reference andpayment amount match but the date is different, but I need to keep the mostrecent line removing the earliest date.

It’s okay to have duplicate reference numbers where thepayment amount is different.

Hope this makes sense.

I'm happy to use VBA or Formula as a solution



Thanks in advance for your help.