Formula to find smallest number in a list

[sobrien1234]

I have a list of horses names in column G with their race times in column AD. There are multiple entries for the horses (i.e. they have up to 6 races and times. There are also multiple races. In column X I have managed to get the horse name listed just once with blanks for all the other entries. I want a formula that gives me their lowest time in column AB so it is in the same row as in column X.

Thanks in advance!!

Seamus

 

[Aladin Akyurek]

Sorry it is working!! Got the columns wrong - thanks a million!!1

You are welcome.

I just used the control shift enter one as I hav used tghat before so didn't try the other one. Thanks again!!

If you have it, MINIFS is faster.