Forum Discussion

CCook's avatar
CCook
Copper Contributor
Mar 28, 2025
Solved

Filter Formula to list values that are greater than and less than criteria from different columns.

I need to make a new column that produces values from Gross Plant Generation >100, and Dry Bulb temps <10, and sort them into a new column by date occurred. I have tried several variations of the following formula, but getting errors: 

=FILTER(B2:C4369,(B2:B4369=">100")*(C2:C4369="<10"),"")

I would like to see the results into cell M5.

 

Thank you in advance!

 

2 Replies

Resources