Positioning teams for tournament

Closed
Laura - Nov 14, 2015 at 05:47 PM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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
0