Positioning teams for tournament
Closed
Laura
-
Nov 14, 2015 at 05:47 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 17, 2015 at 11:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 17, 2015 at 11:57 AM
Hello,
I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points scored. If there are joint points then the order will look at goal difference which is shown in a different column to the points.
Do you know the formula I would need to use?
Many thanks
Laura
I'm creating a spreadsheet for a netball tournament and want it to calculate the finishing positions (1st, 2nd etc) based on the points scored. If there are joint points then the order will look at goal difference which is shown in a different column to the points.
Do you know the formula I would need to use?
Many thanks
Laura
Related:
- Positioning teams for tournament
- Microsoft teams download - Download - Organisation and teamwork
- Funny teams backgrounds - Guide
- Team fortress 2 download for pc - Download - Shooters
- Teams change background outside of call - Guide
- Teams scroll bar missing - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 17, 2015 at 11:57 AM
Nov 17, 2015 at 11:57 AM
Hi Laura,
So the higher the points scored and the higher the goal difference the higher the rank? If that is true then try the following formula:
=RANK(B2,$B$2:$B$6)+SUMPRODUCT(--($B$2:$B$6=B2),--($C$2:$C$6>C2))
Where column B is points scored and column C is point difference.
Best regards,
Trowa
So the higher the points scored and the higher the goal difference the higher the rank? If that is true then try the following formula:
=RANK(B2,$B$2:$B$6)+SUMPRODUCT(--($B$2:$B$6=B2),--($C$2:$C$6>C2))
Where column B is points scored and column C is point difference.
Best regards,
Trowa