FILTERING FOR ZERO VALUES

[tomtingley]

Hi,

I'm looking to create an output where it shows any rows that have a zero in that row and removes any that have a full set of values.

E.G. imagine the first row has values of 54, 10, 23, 0, 4 - i would want this to show in the output because this has a zero.

Whereas a row of 1, 2, 3, 4, 5 - i wouldn't want to show because there is no zero value.

Hope this makes sense.

Thanks,

Tom

[binuacs]

@tomtingley One way of doing this

[tomtingley]

Thanks so much! @binuacs

Would you be able to do that for me on this data set? I get duplicate rows when I try.

I've highlighted the rows with zero values that I want to show in the output.

[binuacs · Accepted solution]

@tomtingley I updated the workflow. Can you check the result and let me know how it looks

[tomtingley]

Amazing! Thanks so much 

[RobertOdera · Accepted solution]

Hi, @tomtingley 

Try this out.

I hope you find it helpful - cheers!

Based on your logic, the desired output is 15 rows (out of 21)...

[tomtingley · Accepted solution]

Thanks a lot, this also works!!

[RobertOdera]

You're most welcome @tomtingley 

@binuacs  solution is more efficient 😎

I wanted to give you a step-through - I appreciate your feedback 👍