Forum Discussion
CCook
Mar 28, 2025Copper Contributor
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!
Try it this way:
=FILTER(B2:C4369,(B2:B4369>100)*(C2:C4369<10),"")
2 Replies
- CCookCopper Contributor
It worked! Thank you!
- Riny_van_EekelenPlatinum Contributor
Try it this way:
=FILTER(B2:C4369,(B2:B4369>100)*(C2:C4369<10),"")