Hello guys
To calculate the growing season start (GSS), I have to extract data above 5 degrees that occur for 6 consecutive days.
How can I do that?
Hello guys
To calculate the growing season start (GSS), I have to extract data above 5 degrees that occur for 6 consecutive days.
How can I do that?
This formula identifies the first value where it and the next 5 are > 5 degrees.
=IF(AND(SUMPRODUCT(--(A3:A8>5))=6,COUNTIF(B$2:B2,"Start")=0),"Start","")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks for the reply
I tried the formula but got an error
Unless you give me sometging to work with... a sample sheet showing the problem, for example, I can do no more.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks