MAX Value with Describing Cell

  • Thread starter Thread starter Deuce Sapp
  • Start date Start date
D

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?
 
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?
 
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

:
 
Back
Top