G
Guest
What I need to know is; How to find the address of the value returned by the
MIN function?
MIN function?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
=Address(min(if(b1=B6:b29,row(B6:b29),3))) entered as an array
formula(Ctrl+Shift+Enter).
Regards
Peter
P
Peo Sjoblom
Or
=CELL("address",INDEX(B6:B26,MATCH(MIN(B6:B29),B6:B26,0)))
it is not volatile and can be entered normally
=CELL("address",INDEX(B6:B26,MATCH(MIN(B6:B29),B6:B26,0)))
it is not volatile and can be entered normally
G
Guest
Thanks! This solved the problem.
Peo Sjoblom said: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
G
Guest
Peter, Peo;
Thanks! your answers solved the problem.
Walt
Thanks! your answers solved the problem.
Walt