Find key words in two columns based on a common column

Question

Not finding anything specific to my question, already asked.

I have rows of data where one specific column (columm A) has dups (based on a join.)  However, there are two more columns per row that have descriptions (columns B and C.)

As an example, I have three rows, whereby column A is the same.  But for columns B and C, only one of the rows is a "match."  And by match, I mean they will share a common word(s).

I need to identify the one row out of the three, where columns B and C have the most matches of words.

ABC1234How now brown cowWhere is the bathroom1234How now brown cowBrown Cow1234How now brown cowThe rain in Spain

Two match example

ABC1234How now brown cowWhere is the bathroom1234How now brown cowBrown Cow1234How now brown cowBrown

I was trying to use the Fuzzy Match tool, but wasn't able to get the desired results.

BrandonB · Accepted Answer

Example method of solving based on a split to rows on space and then count by word type approach. The logic may need to be tweaked depending on your data. Workflow is attached.

mceleavey · Accepted Answer

Hi @Number4 ,

I've attached the fuzzy matching method. This will give you the percentage match score against words, and ranks the rows in matched order.

I hope that helps:

M.