Filter Problem

[Arjay_Aquino]

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

[#2]

Hi @Arjay_Aquino 

Can you show some screen shots on your method of filtering?

[#3]

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 

[#4]

@Arjay_Aquino 

Do we speak about such filtering?