| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index match issue
ok here is my formula:
=INDEX('Performance Summary'!D4:H4,MATCH(MIN('Performance Summary'!D24:H24),'Performance Summary'!D24:H24,0)) Basically the data in cells D4:H4 are years like 2008, 2007 etc. They are the values I need returned. However - in my formula with the MIN section - I only want to include those that are greater then 0. So I need to have cells D24:H24 in there but if say H24 is zero then I don't want it to include that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP/Index&Match data format issue | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| Help with complex index array issue | Excel Worksheet Functions | |||
Threaded Mode
