Custom filter

[Hussein982]

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 solution]

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