Forum Discussion

Jetheat's avatar
Jetheat
Copper Contributor
Sep 09, 2019

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

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

excel

1 Reply

  • Jetheat's avatar
    Jetheat
    Copper Contributor
    Sep 10, 2019

    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

Resources