Google Sheets Match Any Text

In Google Sheets, I have 2 columns (A and B) of text and I'm trying to set up conditional formatting to identify partial duplicates for when these 2 criteria are both met:

  • Text in A exactly matches with any other cell in A

and

  • Any of the individual words in cell B match any of the words in any other cell in B

So, if A2 = "target.com" and B2 = "Big Bonus"

I want it to flag any other cells where A = "target.com" and B = "Bonus Donuts" or "Biggest Exciting Bonus Ever" (because "Bonus" is identified as the duplicate) or "Exciting Big Day" (because "Big" is identified as the duplicate). I need it to be case-agnostic.

Nothing I have tried has even come close to working, so I won't include any of it here.

Sample Data: https://docs.google.com/spreadsheets/d/1DO-0uJRf6MOJ7fJiza5MAmFNIqpCwJ4WMH28j6wp22w/edit#gid=0



Read more here: https://stackoverflow.com/questions/67926525/google-sheets-match-any-text

Content Attribution

This content was originally published by Jake Randall at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: