Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.

What does SLOPE!A507:A606 have to do with it?

In your explanation you mention D and BI but nothing about A?

Your formula is looking for the min from BI in A.

See if this does what you want:

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.

Thank you for your help. It worked, but only after I changed column A
to BI, which was what I should have had to start with. Column A has
absolutely no place in this equation. Thanx again.


On Apr 11, 11:41*am, "T. Valko" wrote:
What does SLOPE!A507:A606 have to do with it?

In your explanation you mention D and BI but nothing about A?

Your formula is looking for the min from BI in A.

See if this does what you want:

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"rhhince" wrote in message
...
Thank you for your help. It worked, but only after I changed column A
to BI, which was what I should have had to start with. Column A has
absolutely no place in this equation. Thanx again.


On Apr 11, 11:41 am, "T. Valko" wrote:
What does SLOPE!A507:A606 have to do with it?

In your explanation you mention D and BI but nothing about A?

Your formula is looking for the min from BI in A.

See if this does what you want:

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606,0))

--
Biff
Microsoft Excel MVP

"rhhince" wrote in message

...

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.

I am not sure which site you use to post your queries. Would suggest to use
the Microsoft site itself.


http://www.microsoft.com/communities...&lang=en&cr=US


If this post helps click Yes
---------------
Jacob Skaria


"rhhince" wrote:

Can someone help me clarify this equation.

=INDEX(SLOPE!D507:D606,MATCH(MIN(SLOPE!BI507:BI606 ),SLOPE!A507:A606))

I am asking excel to go to column D of the SLOPE workbook, match the
minimum of column BI.........All I get is the most current date.
Column D is a date, column BI is the minimum drop in equity. I wish to
retrieve the date of the minimum drop in equity from column BI.

Any help would be appreciated.