Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MIN function
What I need to know is; How to find the address of the value returned by the
MIN function? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
Peter, Peo;
Thanks! your answers solved the problem. Walt "Walt" wrote: What I need to know is; How to find the address of the value returned by the MIN function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |