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

Question

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.&nbsp;

hansvogelaar · Answer

Deleted&nbsp;
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.

peiyezhu · Answer

http://e.anyoupin.cn/EData/927.htmlHow about this?

Forum Discussion

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

2 Replies

Resources