Offset of a minumum
 

Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike

Offset of a minumum
 

Try something like this:

=INDEX(A12:A200,MATCH(MIN(D12:D200),D12:D200,0),1)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Mike K" wrote:

Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike

Offset of a minumum
 

Here is one I posted yesterday for a similar max question.
This is an ARRAY formula which must be entered using ctrl+shift+enter

=INDIRECT("c"&MAX(IF(B1:B11=1,ROW(A1:A11))))

--
Don Guillett
SalesAid Software

"Mike K" wrote in message
...
Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range
in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike

Offset of a minumum
 

One more interpretation:

=INDEX(A12:A200,MATCH(MIN(D12:D200),D12:D200,0)-3)

or you could adjust the ranges
=INDEX(A9:A197,MATCH(MIN(D12:D200),D12:D200,0))
But that looks like a problem when you try to remember why the ranges don't
match.


Mike K wrote:

Oh Wise Ones,
I've got and easy one for you. I have tried several
different setups of trying to find the offset of a minimum. I have a range in
column D (D12:D200) and in column A is the corresponding date. I need to
find the min in col D and find the matching date in col A offset (0,-3) I
believe it would be. Not sure if I use Min of offset or offset of min.
Niether seem to get me what I want. Any help would be appreciated.

Thanks,
Mike

--

Dave Peterson