0

Is there a way to compare 2 columns and highlight those data if column A has a partial match with data in column B?

player0
  • 124,011
  • 12
  • 67
  • 124

1 Answers1

0
=REGEXMATCH(B1, TEXTJOIN("|", 1, A:A))

0

player0
  • 124,011
  • 12
  • 67
  • 124