Filter function using a range of numbers between

[EmmaTM]

Hi,

I am using the following formula which is not working:
=FILTER(Data!A2:Q614,(Data!C2:P614>60.01<71.99))
I only want the data displayed where the numbers are between 60.01 and 71.99
See my original table below.

Thank you

 

[Fluff]

How about

=FILTER(Data!A2:Q614,BYROW(Data!C2:P614,LAMBDA(br,COUNTIFS(br,">60.01",br,"<71.99"))))

 

[EmmaTM]

How about

=FILTER(Data!A2:Q614,BYROW(Data!C2:P614,LAMBDA(br,COUNTIFS(br,">60.01",br,"<71.99"))))

Thank you, I copied this formula but I got #NAME?

 

[Fluff]

Are you using 365 as per your profile?

 

[EmmaTM]

Yes I am

 

[Fluff]

In that case the formula should work. What is the build version you are on?

 

[EmmaTM]

Version 2203 (Build 15028.20248)

 

[Fluff]

In that case you should definitely have all the functions used as the Lambda functions were on release 2202.
Did you copy the formula using the copy icon in the top right of the formula window, or did you re-type it?

 

[EmmaTM]

Hello,
I have just copied from the clipboard and it has now displayed the data, so sorry!

I was expecting the yellows to display (only highlighted for reference on the first row) but not everything else as thats under the 60.01 threshold.

 

[Fluff]

Do you want to keep them in the relevant columns, with everything else "blank"?