+ Reply to Thread
Results 1 to 3 of 3

Random pairs of numbers for team match-ups

  1. #1
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Random pairs of numbers for team match-ups

    Hi intelligent peeps

    I have a spreadsheet with 14, or maybe 16, or maybe 40 names in column B.

    A1 = 1 B1 = JOE CITIZEN
    A2 = 2 B2 = JANE PERSON
    ...
    A17 = 3 B17 = JACK DOE
    and so on...

    I want to randomly assign these names to pairs using a macro button, and basing it on the number of players (C1)

    So if C1 is 12, I'd like the function behind the macro button to come up with 6 * 2 numbers (2 and 11, or 4 and 7, all completely random, but within the 12 specified in C1) and write these random values in Range D1:E6
    (if C1 is 18, then the range to write in would expand to D1:E9).

    I don't know enough about writing code to be able to pull this off Can anyone help me please?

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Random pairs of numbers for team match-ups

    Hi

    Maybe worth look at this link http://www.excelforum.com/excel-gene...-students.html

    Regard
    micope21
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Random pairs of numbers for team match-ups

    Thanks Micope21 for that link, it fits perfectly in with the random format I want to use and I can adapt it (pleasantly) to make someone else authenticate the draw as unbiased with their own choice of word, where "Name Of Teams" is in the spreadsheet !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Random Team Generator
    By bsalomons in forum Excel General
    Replies: 1
    Last Post: 07-12-2013, 03:32 AM
  2. [SOLVED] Random Pairs Macro
    By franguev in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-09-2013, 05:36 PM
  3. Random team picker
    By Sheepkin_Coat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-03-2011, 04:01 PM
  4. Random Pairs
    By golfer2b in forum Excel General
    Replies: 12
    Last Post: 08-26-2010, 02:47 PM
  5. Random Team Generation
    By newbie in forum Excel General
    Replies: 2
    Last Post: 10-07-2005, 01:05 PM

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