MAX Value with Describing Cell

[Deuce Sapp]

I have a table of date/time information in one column and temperature info
in another. I am trying to use a formula to pull the highest and lowest
temperature (pretty easy using MAX / MIN), but can I reference the previous
column to report the date/time information that record temperature was
recorded?

 

[Deuce Sapp]

I realize now that the below example doesn't work because the MAX doesn't
return a cell reference, but an actual value. Is there any way to get the
actual cell that the MAX function locates?

 

[Rafael Ortiz]

You do want the value from the MAX function, so that you know which value to
look for in the range of cells with your temperatures.

I don't know exactly how your sheet looks, but what you need is something
like the following:

=OFFSET(B8,MATCH(MAX(B:B),$B$8:$B$11249,0)-1,-1,1,1)

I don't know what offset you need exactly, but this should get you in the
right direction...

MRO

: