Hi all,
I’ve got an issue within my companies CRM system where there are many duplicate organisations created constantly. I must now identify these duplicate companies however they aren’t always written exactly the same and therefore when I use excel to find duplicates it only highlights the values which are identical
For example:
“Visit Cyprus”
“Cyprus tourist board”
They are the same company however they won’t be pulled in excel as a duplicate.
Is there any way to identify duplicates in this way, I appreciate its quite a difficult question because it’s clearly very different names, but any help is really appreciated.
Thanks
I’ve got an issue within my companies CRM system where there are many duplicate organisations created constantly. I must now identify these duplicate companies however they aren’t always written exactly the same and therefore when I use excel to find duplicates it only highlights the values which are identical
For example:
“Visit Cyprus”
“Cyprus tourist board”
They are the same company however they won’t be pulled in excel as a duplicate.
Is there any way to identify duplicates in this way, I appreciate its quite a difficult question because it’s clearly very different names, but any help is really appreciated.
Thanks