Forum Discussion
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 fol...
Try it this way:
=FILTER(B2:C4369,(B2:B4369>100)*(C2:C4369<10),"")
Try it this way:
=FILTER(B2:C4369,(B2:B4369>100)*(C2:C4369<10),"")