| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba help pls - find min based on a condition and return val of an offset cell
On Mon, 16 May 2005 11:11:47 -0400, "Vasant Nanavati" <vasantn *AT*
aol *DOT* com wrote: Something like: =INDEX(A2:A10,MATCH(MIN(IF(C2:C10="Male",M2:M10)) ,M2:M10,0)) entered as an array formula with <Ctrl <Shift <Enter. -- Vasant Thanks..I will play with that for a while. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS | Excel Worksheet Functions | |||
| Limitations when Combining OFFSET and MATCH to return a cell refer | Excel Worksheet Functions | |||
| find max value in column and return offset of that value | Excel Discussion (Misc queries) | |||
| Fill a cell based on a condition being met | Excel Worksheet Functions | |||
| test cell for text string; return value if condition is true | Excel Programming | |||
Hybrid Mode
