I have a column with a keyword at each row, there are several keywords. Now I want to check, row for row, if any of these keywords occurs in another column. I want this check to be done by using only one column for the calculations.
Ex:
Keywords
test
alpha
house
bike
Column A | Column B
Row tow bow | FALSE
Pest test best | TRUE
Alpha beta gamma | TRUE
xor or and | FALSE
Thanks in advance!
Bookmarks