Thanks! This solved the problem.
"Peo Sjoblom" wrote:
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
"PeterAtherton" wrote in message
...
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
"Walt" wrote:
What I need to know is; How to find the address of the value returned by
the
MIN function?
|