Forum Discussion

Arjay_Aquino's avatar
Arjay_Aquino
Copper Contributor
May 11, 2021

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 than 0.06 but for some reason data that are 0 in value are also showing up.

is there a way to filter data like im trying to do but without the zero showing up?

thank you

3 Replies

  • tusharm10's avatar
    tusharm10
    Brass Contributor
    May 23, 2021

    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))))

    Arjay_Aquino 

Resources