Hi
I have a column of sentences in A, and a list of words in column B. I want the sentences in column A to appear in another target column (for example column C) if a they contain a word (not case sensitive) that is in the list of words in column B, and I do not want the same sentence to appear more than once in the target column.
Any ideas?
Thanks
Njaal, Norway
Bookmarks