One way - (assumes your data is in B2:B4)
=OFFSET(INDEX(B2:B4,MATCH(MAX(B2:B4),B2:B4,0)),0,1 )
"JKJ95" wrote:
I am trying to have Excel give me the Cell Reference of the Max. or Min
number in a range of cells. Once I have this, I would like to incorporate the
reference in the Offset function. Is this possible?
|