Forum Discussion

Allan_Hay's avatar
Allan_Hay
Copper Contributor
Oct 06, 2022
Solved

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's avatar
    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's avatar
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's avatar
    Allan_Hay
    Copper Contributor
    Oct 06, 2022

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

Resources