Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
If, Lookup, Match or a combination of all | Excel Worksheet Functions | |||
Combination...SumProduct, Index, Match? | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
combination of vlookup and match question | Excel Worksheet Functions |