Hello good people of the Excel Forum!

I need some help with an Excel database. (It's some 9000+ lines long!)
Its a database for a mortgage company and it has several duplicate entries.

What I'm supposed to do is remove the duplicate entries but keep the most recent entry for that person.

I can identify duplicates from social security numbers and I have dates of the most recent activity for each loan.

Anyone have a suggestion on how to do this?
If you need more details I can supply them.

Thanks,
Dale