• 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

    Hui...

  • 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

vidchin

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
 

vletm

Excel Ninja
vidchin
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?
 

vletm

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

Attachments

Last edited:
Top