Hi,
I have two sets of data (customer names). The two sets of data are from different sources. Even though they are the same list of customers they are all have slightly different names (not correlated).
They will be partly the same, maybe one or two words the same.
Is there a formula that will be able to highlight and link the two sets of data together?
I don't want to go through manually and link these.
Many thanks,
Matt the novice
I have two sets of data (customer names). The two sets of data are from different sources. Even though they are the same list of customers they are all have slightly different names (not correlated).
They will be partly the same, maybe one or two words the same.
Is there a formula that will be able to highlight and link the two sets of data together?
I don't want to go through manually and link these.
Many thanks,
Matt the novice