| 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
Hi all,
I need vba code that will say: Find the minimum value in col M that is in the same row as the condition "Male" (col C), then return the value (text) from col A in that row. EG: A C M Name Division Time Joe Male 00:05:23 Sue Female 00:06:36 Tom Male 00:04:56 Tim Open 00:04:33 The correct information to return in this example would be "Tom". I need to have "Tom" appear as a lable.caption in a form. I need to be able to code it so that it can find the minimum value for each division (the winner of a race). Any help greatly appreciated. |
| 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 | |||
Threaded Mode
