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

[Deleted]

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 replacement, I want all other job numbers to disappear that do not have just these two jobs. 

[#2]

@Deleted 

Click the filter arrow in the Shallow Overlay column.

Clear the check box for (blanks), then click OK.

You'll see only the rows that have an x in the Shallow Overlay column.

Do the same for the Bridge Replacement column.

[#3]

http://e.anyoupin.cn/EData/927.html

How about this?