I may need some help.
I understand how to retrieve the min and max value from each column. When I try to use a formula of this type, =INDEX(A:A,MAX(B:B),1)
Column A is time date. Column B Max Temp is 53.4 but the formula answer temp is 43.2. with a date stamp of the wrong occurance...