Simple MAXIFS question!

[isaacbetting]

Hi guys, i feel like this should be simple but i have no idea how to do it, would love some help.
Consider the table below.
I need a new column on the end with a formula that provides the maximum value from the position column that also has a 1 in the place field for all records with the same race date time. I hope that makes sense
so for all records with a race time of Cartmel 16/07/2009 14:00 the new column would show 3 because 3 is the highest position that got a place in that race. Whereas all records with a race time of leicester 16/07/2009 14:10 would show a 2[TABLE="width: 380"]
<tbody>[TR]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]




[TABLE="width: 380"]
<tbody>[TR]
[TD]Race date Time[/TD]
[TD]Position[/TD]
[TD]Place?[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:00[/TD]
[TD="align: right"]247[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester 16/07/2009 14:10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester 16/07/2009 14:10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester 16/07/2009 14:10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester 16/07/2009 14:10[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Leicester 16/07/2009 14:10[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hamilton 16/07/2009 14:20[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cartmel 16/07/2009 14:30[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Hi & welcome to MrExcel.
How about
=MAX(IF(($A$2:$A$34=A2)*($C$2:$C$34>0),$B$2:$B$34))

This needs to be confirmed with Ctrl Shift Enter, not just Enter

 

[isaacbetting]

cheers mate that's worked a treat

 

[Fluff]

You're welcome & thanks for the feedback