I Cannot thank you enough Hui, I've been wrestling for days trying to find the answer thank you, thank you, thank you ...... you are a true excel ninja :)
Hi,
My aim is to calculate GDD in excel where in column A I got date and hour (reading taken hourly) and in column B is the outdoor temperature. I need to find the maximum outdoor temp. for that day subtract the minimum outdoor temperature and then divided by 2 and the result should show in...