consecutive date and tempreature range

[vidchin]

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

 

[vletm]

vidchin
Based Your the last word and Forum Rules

Site Rules - New Users - Please Read

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

chandoo.org

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?

 

[vidchin]

please have look at columns AV and BG. these are dates . i want to know the no of consecutive days(2 ore more) .

Regards
Vidya

 

[vletm]

vidchin
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.