SOLVED

Cell is equal to X but less than XX

New Contributor

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. 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution
=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 Thank you so much, makes so much sense now i see it.