Filter Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2343098%22%20slang%3D%22en-US%22%3EFilter%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2343098%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20filter%20sets%20of%20data%20so%20it%20will%20only%20show%20data%20that%20are%20greater%20than%20or%20less%20than%20a%20particular%20value.%3C%2FP%3E%3CP%3Eso%20i%20set%20the%20filter%20to%20show%20data%20that%20are%20greater%20than%200.2%20or%20data%20that%20are%20less%20than%200.06%20but%20for%20some%20reason%20data%20that%20are%200%20in%20value%20are%20also%20showing%20up.%3C%2FP%3E%3CP%3Eis%20there%20a%20way%20to%20filter%20data%20like%20im%20trying%20to%20do%20but%20without%20the%20zero%20showing%20up%3F%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2378346%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2378346%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050361%22%20target%3D%22_blank%22%3E%40Arjay_Aquino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20show%20some%20screen%20shots%20on%20your%20method%20of%20filtering%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

Hi @Arjay_Aquino 

 

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

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 

@Arjay_Aquino 

Do we speak about such filtering?

image.png