Simple MAXIFS question!

isaacbetting

New Member
Joined
Jul 24, 2019
Messages
2
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



<tbody>
</tbody>




Race date TimePositionPlace?
Cartmel 16/07/2009 14:0010
Cartmel 16/07/2009 14:0021
Cartmel 16/07/2009 14:0031
Cartmel 16/07/2009 14:0040
Cartmel 16/07/2009 14:0050
Cartmel 16/07/2009 14:0060
Cartmel 16/07/2009 14:0070
Cartmel 16/07/2009 14:0080
Cartmel 16/07/2009 14:0090
Cartmel 16/07/2009 14:00100
Cartmel 16/07/2009 14:002470
Leicester 16/07/2009 14:1010
Leicester 16/07/2009 14:1021
Leicester 16/07/2009 14:1030
Leicester 16/07/2009 14:1040
Leicester 16/07/2009 14:1050
Hamilton 16/07/2009 14:2010
Hamilton 16/07/2009 14:2021
Hamilton 16/07/2009 14:2030
Hamilton 16/07/2009 14:2040
Hamilton 16/07/2009 14:2050
Hamilton 16/07/2009 14:2060
Hamilton 16/07/2009 14:2070
Cartmel 16/07/2009 14:3010
Cartmel 16/07/2009 14:3021
Cartmel 16/07/2009 14:3031
Cartmel 16/07/2009 14:3040
Cartmel 16/07/2009 14:3050
Cartmel 16/07/2009 14:3060
Cartmel 16/07/2009 14:3070
Cartmel 16/07/2009 14:3080
Cartmel 16/07/2009 14:3090
Cartmel 16/07/2009 14:30100

<tbody>
</tbody>
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top