Need Help with Formula

[rudagar]

I'm trying to figure out a way to set up a complicated? matching.

My tables can be seen at http://hrmleague.co.nr

What I want to do is to be able to have it so my "Top Horses" table can automatically update the horses "MARK" when it is lowered.

Basically, what it is going to do is this:

Look in Owner sheet B11:B-whatever(NAME) for where it matches the horse's name.
From there, I need to check for column H(FINISH) is 1.

That part is easy enough for me, but now:

I need to take the lowest value for the "MILE TIME"(Col L) in which these conditions are me.

I know I probably need an array returning the matches, and then use MIN to find the lowest time, but I have no idea how.


I hope this is explained clear enough.

[carl]

maybe the function SMALL( returns the k-th smallest of a sample) will help
_________________
carl
Using OpenOffice.org 2 on XP sp2