Forum Discussion
Solved
Filter rows if multiple columns have values are 0
How do I filter out rows that have zeros in multiple columns?
Hi kekepania052970,
You can create a custom column with rule of
if Coulmn1 = 0 and
Column2 = 0 and
Column3 = 0 and
etc.
then "Hide"
else "Show"
then filter the custom column to Show.
Hope this helps
Hi kekepania052970,
You can create a custom column with rule of
if Coulmn1 = 0 and
Column2 = 0 and
Column3 = 0 and
etc.
then "Hide"
else "Show"
then filter the custom column to Show.
Hope this helps
I ended up using the following filter on one of the number columns:
if Coulmn1 <> 0 or
Column2 <> 0 or
Column3 <> 0 or
etc.