Multiple Columns Filter

[pchong]

Hi Community,

I am trying to do a multi-column (different names) filter with similar condition.

Please see below for an example I made.

Input :

Desired Output :

Basically, a simpler or smarter way to do this 

[ IF Criteria1 = "N" or Criteria2 = "N" or Criteria3 = "N" or Criteria4 = "N" ]

I have more than 20 criterias/columns to be filtered. Instead of writing a long OR statement, what is a better way?

Thank you.

[binu_acs]

@pchong One way of doing this