Forum Discussion
Filter Problem
I am trying to filter sets of data so it will only show data that are greater than or less than a particular value. so i set the filter to show data that are greater than 0.2 or data that are less t...
Zero is less than 0.06. So, it should show up in the filtered list.
If you want to exclude zero values, you should explicitly do so. E.g.
=FILTER(S2:S8,(S2:S8>0.2)+((S2:S8>0)*(S2:S8<0.06)))
And, to improve maintainability...replace the repeated references to the source range,
=LET(_Rng,S2:S8,FILTER(_Rng,(_Rng>0.2)+((_Rng>0)*(_Rng<0.06))))