+ Reply to Thread
Results 1 to 2 of 2

Random Team Generator

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Red Deer
    MS-Off Ver
    Excel 2010
    Posts
    1

    Random Team Generator

    I am organizing a sports tournament and would like excel to randomly generate the teams for it.

    We have 20 people who will be organized into 10 teams of two.

    What I am looking for help on is how to setup the formula to have two people randomly paired together without duplication. The names will be further used in other formulas for points calculations.

    So, I have the names as A1:A20 and then would like the teams generated from B1:B10 and C1:C10 with the team being the row and the team members in the B and C columns.

    Thanks!

    Brett

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Random Team Generator

    HI Bsalomons,

    welcome to the forum.
    See the attached file and click on blue button to generate the random team members without duplication (will take some time to process)

    random team generation.xlsm


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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