Find key words in two columns based on a common column

[Number4]

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.

A	B	C
1234	How now brown cow	Where is the bathroom
1234	How now brown cow	Brown Cow
1234	How now brown cow	The rain in Spain

Two match example

A	B	C
1234	How now brown cow	Where is the bathroom
1234	How now brown cow	Brown Cow
1234	How now brown cow	Brown

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

[BrandonB · Accepted solution]

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 solution]

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.