Identify duplicates based two or more fields
Hi,
I am creating a contacts directory which will be populating the contact information of our collaborators across the globe. This form will be completed by various team members and there is a chance to enter the same contact information by multiple team members. Fileds like First Name, Last Name, Country, Institution, Email and Profession will be captured, and Email column may more than one email separated by semicolon.
Now, I want to identify the duplicates based on common first name, last name, country and Institution. I am looking for a workaround to send me a notification, whenever a duplicate row was added with same information (identical first name, last name, country and Institution). I was able to create and identify duplicate rows using the email column alone. But this did not seem to be efficient in my scenario, since the first entered information may one email and next one might have two emails (but both the rows have same persons info). So, creating a workflow that identifies common fields would be helpful.
or please provide me any other suggestions that would be helpful.
Thanks,
Mounika
Best Answer
-
Hi @Mounika,
You can create a checkbox column called "Duplicate" (or whatever you want) and use the following formula.
=IF(COUNTIFS([First Name]:[First Name], [First Name]@row, [Last Name]:[Last Name], [Last Name]@row, Country:Country, Country@row, Institution:Institution, Institution@row) > 1, 1)
Hope that helps,
Dave
Answers
-
Hi @Mounika,
You can create a checkbox column called "Duplicate" (or whatever you want) and use the following formula.
=IF(COUNTIFS([First Name]:[First Name], [First Name]@row, [Last Name]:[Last Name], [Last Name]@row, Country:Country, Country@row, Institution:Institution, Institution@row) > 1, 1)
Hope that helps,
Dave
-
Hi @DKazatsky2
That worked. Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives