Hi folks, I have a spreadsheet which currently has a list of teams in a table and a list of fixtures for the table, when i enter in a result of a fixture the table gets automatically updated with the points for and against and the actual points for that team, and it moves them up or down accordingly based on vlookups and ranking.
However this currently only works for 4 teams, and i have to manually type out the fixtures. What i was wondering was is there anyway to be able to increase the size of the table and vlookup will include all the new teams. Also is it possible to enter in a list of teams in teh table and then it automatically generates the fixtures based on all the teams in the table?! Does that make sense? The spreadsheet is for gaelic football and thats why there are 2 scores in a result i.e. 1 - 1 or whatever, so dont get confused by the scoring format!!
The spreadsheet can be seen here:
http://www.theshamrocks.co.uk-a.goog...sultstable.xls
Thanks for any help!
Thanks in advance
Bookmarks