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.