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 data in the "G" column is greater than 15. I need to extend on this and only show data that is greater than 15 bu less than 30?

 

=FILTER(DATA!A2:G201,DATA!G2:G201>15)

 

 

Thank you in advance for any assistance you can offer. 

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.

2 Replies

  • 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.

Resources