In the attached workbook a graph shows the Min & Max temps recorded at a location. I am hoping to find a way to list all dates in cell I37 and below where by for three consecutive days the maximum temperature was plus or minus 1 of the selected temp in cell G37. If no dates were found then the cell I37 should show the value "None found". If any dates are found, can the listing be shown as date to date in the cell (eg 2/3/24 to 5/3/24). The data in columns A to E will continue to grow over time.
On a side note the chemical "Formic Pro" has a preferred safe use range of 10° to 25° celcius, and I'm trying to identify periods where I might have been able to apply the product as a method of Varroa Mite control.
Any assistance would be greatly appreciated.
Reply With Quote