Offset of a minumum

[Mike K]

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 (D12200) 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

 

[Ron Coderre]

Try something like this:

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

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

XL2002, WinXP

 

[Don Guillett]

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))))

 

[Dave Peterson]

One more interpretation:

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

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