Hi all,

Assuming that I have some words in column A and I specifically want to retrieve those rows with the word "Apple" or "Orange" which do not exist in the same row:

Item (column A) Extracted column (column B)
Apple is a good fruit Apple is a good fruit
mango
banana
HOT turkey
I love oranges I love oranges
Red Apples Red Apples
Red Oranges Red Oranges


What is the formula that I should use in order to get the answers in column B ?

Appreciate all your kind reply!!