• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

consecutive date and tempreature range


New Member
i have file with date and temperature. I need to know that if three/two consecutive days the temperature was more. what should i use the formula as ? my data is for thirty years. pls help urgent


Excel Ninja
Based Your the last word and Forum Rules
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?


Excel Ninja
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.


Last edited: