+ Reply to Thread
Results 1 to 2 of 2

Round Robin: Columns vs. Rows

  1. #1
    Registered User
    Join Date
    11-27-2006
    Posts
    5

    Round Robin: Columns vs. Rows

    I've searched for "round robin", and unfortunately, I couldn't find what I think I stumbed on a few months ago...eeee.

    I'd like to create a spreadsheet that will combine the column vs. the row for a round robin...and the list will be a straight column.

    There could be an uneven # of either column or row...

    The numbers would be generated by formula too, hopefully....
    hd1 hd2 hd3 hd4
    hl1 1 5 9 13
    hl2 14 2 6 10
    hl3 11 15 3 7
    hl4 8 12 16 4

    1 b2 a2
    2 c3 a3
    3 d4 a4
    4 e5 a5
    5 c2 a2
    6 d3 a3
    7 e4 a4
    8 b5 a5
    and so on

    any idears?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Try this; it will do round-robin tournaments with up to 30 teams.
    Attached Files Attached Files

+ 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