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
Related:
- Positioning teams for tournament
- Microsoft teams download - Download - Organisation and teamwork
- Team fortress 2 download for pc - Download - Shooters
- Funny teams backgrounds - Guide
- 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
