FILTERING MULTIPLE COLUMNS

Hi Guys,

What will be the syntax in filtering multiple columns where all should be null. The input file look like this for example.

And the results should look like this. Can Filter tool able to remove the row where the last 4 columns are null.

Here's the excel file attached.

Thanks,

Kamen

Workflow

Accepted answers

@KamenRider find the workflow attached
mark done if solved.

Use the filter tool and use the following formula

IsNull([Column1]) AND IsNull([Column2]) AND IsNull([Column3])

Change the name of the columns for your columns and that should be enough.

@KamenRider find the workflow attached
mark done if solved.

@KamenRider the solution is dynamic and will work for N number of columns.