Filter multiple columns to show rows that satisfy the criteria in either columns

Hi I'm trying to solve a problem where I need to be able to filter a table with multiple columns. The usual filter function shows the rows that satisfy the criteria of the filter in that single column and if I were to filter on multiple columns it would only show the rows that satisfied the criteria in both columns. I need to be able to show the rows that satisfy the criteria in either columns not both.

Example sheet attached. I want to filter to only show the changes that are yes to either the red team or the green team - i.e. hide Change5 but the rest should stay.

Thanks,

David

Legend, that worked great. Thanks very much for your help

You are welcome.

If your query is resolved, please mark the thread as solved by using thread tool found at top right of your initial post.