Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
from How to get the Best Results at Chandoo.org
... For the best/fastest results, Upload a Sample File ( that means Excel-file; data with expected results)
Have Your read those Rules?
C-column has date and maybe F-column has temperature.
A,B ... could forget. What for are other columns? Duplications?
If You would like to know that something is more - then You should explain - where to compare?
... or from column F ...
cell F4 is more than cell F3 ... not match with Your 'more'?
Just curious, 1st of May, 2019 - seems to be a hot hot day? 99.9
I did one sample, with that You could get something.
Note: I cleaned some cells.
Check ranges F2:I5 from both 'data'-sheets.
You can set Your 'trigger' values to cells H2 & I2 to see some counts.