Data Set of 70,000 contact records with multiple duplicate entries where name, address, and email may have changed
Data includes: Entry ID, Entry date, First, Last, Email, Street, City, Zip, Source,
What formula can I use to filter and copy to another sheet
- Duplicates based on email where only most recent instance is kept and others are removed to another sheet and
- Duplicates based on name where only most recent instance is kept and others are removed to another sheet
- These duplicates matched by address and then only most recent entry is kept and others removed to a third sheet.
- Those uniques matched with duplicate address entries to isolate couples and households.
And when do I append:
Email deliverability status? What if the most recent entry is a fictitious entry and uses a bogus email? I don't want to get rid of the good email associated with a contact
Also, most recent entry may have excluded the full address, how would I preserve that part of the contact record in my spreadsheet?