Oct 06 2022 10:21 PM
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.
Oct 06 2022 10:27 PM
SolutionOct 06 2022 10:32 PM
@Sekoleyte Thank you so much, makes so much sense now i see it.
Oct 06 2022 10:27 PM
Solution