Thread: MIN function
View Single Post
  #2   Report Post  
PeterAtherton
 
Posts: n/a
Default

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?