She wanted to be able to enter the results onto a sheet and have the league table automatically update to rank teams appropriately.
The spreadsheet allows 5 points for a win and 3 for a draw. 1 point is earned if the losing team scores half the points of the winning team. It also provides the ability deduct penalty points from a team.
Download the Netball league table spreadsheet.
The spreadsheet demonstrates some awesome Excel skills that are worth adding to your existing skillset. These include;
- The use of Tables for intelligent referencing within formulas, and to the make the ranges dynamic.
- The Vlookup function to retrieve data for the league table.
- The Sumproduct function to perform multiple conditional testing.