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
- Teams download - Download - Organisation and teamwork
- Funny teams backgrounds - Guide
- Teams change background outside of call - Guide
- Team fortress 2 download for pc - Download - Shooters
- Hello team whatsapp i have not done anything wrong and i'm sure i have followed your rules of conduct and you have suspended my account for not any valid reason please back my account as soon as possible my number() thank you so much - Facebook Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
