Custom filter

Question

Hi All: I have a file with two columns. 1st column called MIN level and 2nd column called MAX

The goal is try to

1- FILTER OUT all the 0 and blank ( blank = does not have a value) in both columns (Min and max)

2- FILTER IN all cells that has value > 0 in both columns (Min and max)

How can you help? attached screenshot for your reference.

thank you in advance

danilang · Accepted Answer

Hi @Hussein982

[Min]>0 and [Max]>0  will handle both cases.  Any record where both Min and Max >0 will be on the True output.   Any record that has either value <=0 or null(blank) will end up in the F output

Dan