Filtering all data by one column that CONTAINS a defined set of words

[Dougmeister]

I have a list of eleven (11) terms by which that I need to filter the data in column "C". If any row contains any of these terms, I want to show only those rows.

I can keep it on the same tab.

I need to repeat this every month with new data.

What is the easiest way to do this?

 

[Dougmeister]

I still think that my sample data is representative of the format of the actual data; could it be choking on the sheer volume?

Can we post actual workbooks to this site?

 

[Marcelo Branco]

Take a look at section B in
https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

M.

 

[Dougmeister]

Ok. I figured it out. Thanks.