MIN function

[Walt]

What I need to know is; How to find the address of the value returned by the
MIN function?

 

[PeterAtherton]

Assuming that the data is in column c check column is B.

=Address(min(if(b1=B6:b29,row(B6:b29),3))) entered as an array
formula(Ctrl+Shift+Enter).

Regards
Peter

 

[Peo Sjoblom]

Or

=CELL("address",INDEX(B6:B26,MATCH(MIN(B6:B29),B6:B26,0)))

it is not volatile and can be entered normally

 

[Walt]

Thanks! This solved the problem.

Or

=CELL("address",INDEX(B6:B26,MATCH(MIN(B6:B29),B6:B26,0)))

it is not volatile and can be entered normally


--

Regards,

Peo Sjoblom

 

[Walt]

Peter, Peo;

Thanks! your answers solved the problem.

Walt