Is there any way of identify similarities between two cells

[Welsh Mark3]

For example the 2 cells below - Is there a formula that can be used to create a likeness %,

Row 1 I would say is a match as they contain keywords, row 2 is not a match as there is no similarity

I am open to all recommendations

BECKER MATT

MATTHEW BECKER CONSTRUCTION, LLC

<tbody>
</tbody>

ALAMO RETAIL SOLUTIONS

BUFFETS INC CABINET DIVISION <tbody> </tbody>

<tbody>
</tbody>

 

[Roderick_E]

Be hard to do with a formula but you could create a macro that loops through every word in won cell see if it exists in another. You would want to build an exclusion list to weed out definite articles like "the" and "a".

 

[njimack]

See this thread

 

[Welsh Mark3]

See this thread

Does this function require columns C D etc?