# 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
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

Related:

## 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
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