Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

split 16 items randomly into two groups

  • 16-04-2014 12:02PM
    #1
    Guffy
    Registered Users, Registered Users 2 Posts: 8,464 ✭✭✭


    I'm running a football league and I have 16 teams that I want to randomly separate into two groups of 8. They are currently in column A2-A17. I was thinking the best way to do it was to assign a 1 or 2 evenly to column B? any ideas on how to do this?


Comments

  • #2
    highly1111
    Registered Users, Registered Users 2 Posts: 961 ✭✭✭highly1111


    Use the rand function on excel. If you put =randbetween(number,number) so =randbetween(1,16) it will populate a number. Hit enter 8 times and you'll get 8 random numbers and they can be league A, other teams league B.


  • #3
    bardcom
    Registered Users, Registered Users 2 Posts: 290 ✭✭bardcom


    gufc21 wrote: »
    I'm running a football league and I have 16 teams that I want to randomly separate into two groups of 8. They are currently in column A2-A17. I was thinking the best way to do it was to assign a 1 or 2 evenly to column B? any ideas on how to do this?

    Here's random. Order the teams as follows. If any objections you can blame a randomer on boards :-)

    12 v 3
    5 v 9
    8 v 1
    11 v 13
    6 v 7
    10 v 16
    4 v 15
    14 v 2


Advertisement
Advertisement