Filter Multiple Columns

[Dan.Reynolds]

Hi,
I have 1000's of rows of data and 8 of the columns are reserved to tag possible defects. All 8 columns pull from the same drop down list of all possible defects. I have 8 columns set aside because a row may contain multiple defects.

What I want to do is look up a single defect (ie "scratches") within all 8 columns. See my attached simplified example. If I filter column B for scratches, the scratched part in row 4 will be ignored. Can I apply a filter across multiple columns?

Thank you.Filter Example.xlsx

[Ace_XL]

Try a helper column. In this column use

=COUNTIF(A2:H2,"Scratch")>0

copy down

Now filter for TRUE on this helper column