Setting up a Football League Table
Looking to set this up in the easiest way possible, i'm new to excel see. I
have a fixture list with 16 team names, all matches are played home and away, with possible results being win, lose or draw. 3 points are awarded for a win, 1 for a draw and none for a loss. I also want to include goals for and against and a goal difference and final total points, ideally when the results are added on the first workbook i would like the league table to be sorted automatically. Basically it's what is printed in the papers every week. Looking forward to your replies. -- Cheers Stashski |
Setting up a Football League Table
Bob Phillips has just the thing you need at his site:
http://www.xldynamic.com/source/xld.LeagueTable.html Hope this helps. Pete On Sep 29, 10:53*am, stashski wrote: Looking to set this up in the easiest way possible, i'm new to excel see. I have a fixture list with 16 team names, all matches are played home and away, with possible results being win, lose or draw. 3 points are awarded for a win, 1 for a draw and none for a loss. I also want to include goals for and against and a goal difference and final total points, ideally when the results are added on the first workbook i would like the league table to be sorted automatically. Basically it's what is printed in the papers every week. Looking forward to your replies. -- Cheers Stashski |
All times are GMT +1. The time now is 01:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com