How can I check yes for X values in multiple columns in Excel?

I am looking to be able to click yes on multiple columns and then it take away the row values that do not match. For example, I want a job that has a Shallow Overlay and a job that has a bridge repla...