+ Reply to Thread
Results 1 to 2 of 2

Excel spreadsheet table auto generate fixtures

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    London
    Posts
    2

    Excel spreadsheet table auto generate fixtures

    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

  2. #2
    Registered User
    Join Date
    12-17-2008
    Location
    London
    Posts
    2
    anyone got any idea? i just want to automatically generate fixtures based on the teams in the table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1