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>
<tbody>
</tbody>
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 Time | Position | Place? | |
Cartmel 16/07/2009 14:00 | 1 | 0 | |
Cartmel 16/07/2009 14:00 | 2 | 1 | |
Cartmel 16/07/2009 14:00 | 3 | 1 | |
Cartmel 16/07/2009 14:00 | 4 | 0 | |
Cartmel 16/07/2009 14:00 | 5 | 0 | |
Cartmel 16/07/2009 14:00 | 6 | 0 | |
Cartmel 16/07/2009 14:00 | 7 | 0 | |
Cartmel 16/07/2009 14:00 | 8 | 0 | |
Cartmel 16/07/2009 14:00 | 9 | 0 | |
Cartmel 16/07/2009 14:00 | 10 | 0 | |
Cartmel 16/07/2009 14:00 | 247 | 0 | |
Leicester 16/07/2009 14:10 | 1 | 0 | |
Leicester 16/07/2009 14:10 | 2 | 1 | |
Leicester 16/07/2009 14:10 | 3 | 0 | |
Leicester 16/07/2009 14:10 | 4 | 0 | |
Leicester 16/07/2009 14:10 | 5 | 0 | |
Hamilton 16/07/2009 14:20 | 1 | 0 | |
Hamilton 16/07/2009 14:20 | 2 | 1 | |
Hamilton 16/07/2009 14:20 | 3 | 0 | |
Hamilton 16/07/2009 14:20 | 4 | 0 | |
Hamilton 16/07/2009 14:20 | 5 | 0 | |
Hamilton 16/07/2009 14:20 | 6 | 0 | |
Hamilton 16/07/2009 14:20 | 7 | 0 | |
Cartmel 16/07/2009 14:30 | 1 | 0 | |
Cartmel 16/07/2009 14:30 | 2 | 1 | |
Cartmel 16/07/2009 14:30 | 3 | 1 | |
Cartmel 16/07/2009 14:30 | 4 | 0 | |
Cartmel 16/07/2009 14:30 | 5 | 0 | |
Cartmel 16/07/2009 14:30 | 6 | 0 | |
Cartmel 16/07/2009 14:30 | 7 | 0 | |
Cartmel 16/07/2009 14:30 | 8 | 0 | |
Cartmel 16/07/2009 14:30 | 9 | 0 | |
Cartmel 16/07/2009 14:30 | 10 | 0 |
<tbody>
</tbody>