Why not try scrubbing the data first, using find & replace to take out Inc,
LLC, or other unwanted characters in both tables.

Then in one of the tables add an additional column that uses a vlookup
formula to compare the Company Name. If it gets a match the Company Name
should pop up in the column, indicating a match. ...If you have other
columns of data such as phone number, url, or email address you might not
have to scrub the data first?



"MEAD5432" wrote:

I have a list of contacts and would like to compare it to another list from a
different department to find duplicates.

The issue is that some of the information on both lists are recorded with
slight variations (one includes Inc. while other doesn't, etc...). Normally,
I could mark duplicates using conditional formatting but it only considers
exact duplicates rather than looking for similarity.

Does anyone know of any good plugins to accomplish this or a way to create a
find duplicate function that has a bit more tolerance for variation?

Thanks.