Filtering a List With a Bunch of Words on Another List - Excel For Mac

Copper Contributor

I have a main list.
I want to filter this list with a bunch of words which I have listed on another sheet.
So I want the main sheet to only show rows which "contain" (not full exact match) any of the words from the other list.

How do I do that?

JH

1 Reply

I have attached a workbook which has two sheets.

  • Main List
  • Filter List

I have made both lists as tables.

I would like to filter the main list if it contains any word from the rows within the filter list.

Any suggestions?

JH