+ Reply to Thread
Results 1 to 3 of 3

Random team picker

  1. #1
    Forum Contributor
    Join Date
    02-10-2007
    Location
    Manchester, England
    MS-Off Ver
    2013
    Posts
    133

    Random team picker

    I have got a list of soccer teams on sheet from column c row 7 to 44, what i want is vba to pick the teams to play each other, so like this

    Saudi Arabia - Brunei
    there are 38 teams altogether

    and so on, but random, can this be done.

  2. #2
    Registered User
    Join Date
    01-02-2011
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Random team picker

    You could try the below formula you would need to create to cells Team 1 Team 2 (or similar) and apply the formula to each cell.... if you want to select another two teams press F9 - it might on occassion choose the same two teams but pressing F9 will select another.

    =INDEX($C:$V,RANDBETWEEN(1,COUNTA($C:$C)),1)

  3. #3
    Forum Contributor
    Join Date
    02-10-2007
    Location
    Manchester, England
    MS-Off Ver
    2013
    Posts
    133

    Re: Random team picker

    Thats not what i want i want to be able to press a command button and it does a draw not picking the same teams i could post a copy of the sheet that i have done

+ 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