Filter out words using the Filter Function with Table References

[Excel2021]

Hello,

I am using the filter function to pull data from a table in excel using table references. I need to filter out any row containing 2 specific words in a specific column. I am having difficulty doing this with table references as all the examples online show this done with cell ranges not table references/ranges. I have attached an image with my filtered results/formula in Cell I4 as I am unable to add the workbook. I would like to filter out any row in the "Customer Name" column with the words "Lemon" or "Pear".

 

[Excel2021]

Thanks, that works exactly how I wanted it to in the example file.

Actually, I just realized that I had made a mistake with my original formula. You can also duplicate the first step you gave me and change the GL and that will work but your formula is much cleaner.

 

[Fluff]

Glad we could help & thanks for the feedback.