Forum Discussion
Anonymous
Aug 08, 2023How 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...
HansVogelaar
Aug 08, 2023MVP
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.