SOLVED
FILTERING MULTIPLE COLUMNS
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
KamenRider
11 - Bolide
05-30-2024
12:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Tips and Tricks
- Workflow
3 REPLIES 3
juvillalobos
7 - Meteor
05-30-2024
01:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Raj
16 - Nebula
05-30-2024
01:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider find the workflow attached
mark done if solved.
Raj
16 - Nebula
05-30-2024
01:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider the solution is dynamic and will work for N number of columns.
