Forum Discussion
MCFNeil
Qrew Captain
Here is an idea. (Not perfect, but might help you narrow the list)
Export the entire list to excel with the: Record ID# and Email.
Use the excel function to "remove duplicates" based on the email.
Then create a new column called [Unique Email Checkbox].
After you have removed all of the duplicates, put the value of 1 in the new column.
Then Import those records back with just the RID and a new checkbox field. All your unique emails will have a checkbox checked.
....
If you do this for phone numbers and possibly full names, you could get a pretty narrow list of contacts, that don't have any checkboxes check. Now you know those are most likely duplicates, or not good information to begin with.
Export the entire list to excel with the: Record ID# and Email.
Use the excel function to "remove duplicates" based on the email.
Then create a new column called [Unique Email Checkbox].
After you have removed all of the duplicates, put the value of 1 in the new column.
Then Import those records back with just the RID and a new checkbox field. All your unique emails will have a checkbox checked.
....
If you do this for phone numbers and possibly full names, you could get a pretty narrow list of contacts, that don't have any checkboxes check. Now you know those are most likely duplicates, or not good information to begin with.
MCFNeil
7 years agoQrew Captain
Ideally at the end of this you make the 'email' field be unique for all future contacts, and avoid having to consolidate.