Cell is equal to X but less than XX

Hi Everyone, I hope someone can help ia currently using the below formula to reference a range of data in a separate sheet. The below formula show a list of data from the separate sheet where da...

BI & Data Analysis

excel

Formulas and Functions

Sekoleyte
Oct 06, 2022
=FILTER(DATA!A2:G201,(DATA!G2:G201>15)*(DATA!G2:G201<30))
if you want to equal as well, you need to use "<=" and ">=" instead of "<" and ">" respectively.

Sekoleyte

Iron Contributor

Oct 06, 2022

=FILTER(DATA!A2:G201,(DATA!G2:G201>15)*(DATA!G2:G201<30))
if you want to equal as well, you need to use "<=" and ">=" instead of "<" and ">" respectively.

Allan_Hay

Copper Contributor

Oct 06, 2022

Sekoleyte Thank you so much, makes so much sense now i see it.

Forum Discussion

Cell is equal to X but less than XX

Resources