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]

Try to post a small sample (input) along with the desired output.

 

[sobrien1234]

Try to post a small sample (input) along with the desired output.

ee below

See below but there are hundreds of different horses names in G - I need something to copy down in AB to get the lowest number for Jack from column AD

G	X	AB	AD
Name
Jack			3
Jack			4
Jack			7
Jack			8
Jack			1
Jack			8
Jack			9
Jack	Jack	1	20
Jack			16
Jack			14

<colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

What is X?

What is that 1 in AB?

What is the expected result? If it's 1, why is this posted in the row in X with Jack?

 

[sobrien1234]

All the letters at the top are the columns. The 1 in AB is hopefully the result of the formula I can drag down the entire column for all horses. It will search all numbers in row AD corresponding to Jack in column G and then put the result in column X in the same row that Jack is isolated in column X.

I know it's confusing!

 

[Aladin Akyurek]

If MINIFS is available on your system...

In AB2 just enter and copy down:

=IF($X2="","",MINIFS($AD$2:$AD$11,$G$2:$G$11,$X2))

Otherwise, in AB2 control+shift+enter, not just enter, and copy down:

=IF($X2="","",MIN(IF($G$2:$G$11=$X2,$AD$2:$AD$11)))

 

[sobrien1234]

If MINIFS is available on your system...

In AB2 just enter and copy down:

=IF($X2="","",MINIFS($AD$2:$AD$11,$G$2:$G$11,$X2))

Otherwise, in AB2 control+shift+enter, not just enter, and copy down:

=IF($X2="","",MIN(IF($G$2:$G$11=$X2,$AD$2:$AD$11)))

This doesn't appear to work - note there are about 2000 rows and over 100 different horses - also some horse may have 5 entries, some 10, some 3 (i.e. all different). Currently it's just giving me the lowest number in row AD not the lowest number corresponding to each horses name.

 

[sobrien1234]

This doesn't appear to work - note there are about 2000 rows and over 100 different horses - also some horse may have 5 entries, some 10, some 3 (i.e. all different). Currently it's just giving me the lowest number in row AD not the lowest number corresponding to each horses name.

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

 

[Aladin Akyurek]

This doesn't appear to work - note there are about 2000 rows and over 100 different horses - also some horse may have 5 entries, some 10, some 3 (i.e. all different). Currently it's just giving me the lowest number in row AD not the lowest number corresponding to each horses name.

Did you test it at all? If you did, which formula have you picked out?

 

[sobrien1234]

Did you test it at all? If you did, which formula have you picked out?

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