[Solved] Random team assignments

[imacanuck]

Hello all,

I'm looking to create a spreadsheet that will take the names of 6 people and randomly split the names into 2 groups of 3. This will have to be done 9 times without any duplication.

Any help would be appreciated.

Thanks.

[lader]

it can be done 10 times - example:

Code: Select all

[A,B,C][D,E,F] 01
[A,B,D][C,E,F] 02
[A,B,E][C,D,F] 03
[A,B,F][C,D,E] 04
[A,C,D][B,E,F] 05
[A,C,E][B,D,F] 06
[A,C,F][B,D,E] 07
[A,D,E][B,C,F] 08
[A,D,F][B,C,E] 09
[A,E,F][B,C,D] 10

[MrProgrammer]

I'm looking to create a spreadsheet that will take the names of 6 people and randomly split the names into 2 groups of 3. This will have to be done 9 times without any duplication.

202402211246.ods

(14.78 KiB) Downloaded 46 times

Put the names of the people in sheet Roster. Nine distinct, randomly-chosen groupings will appear in sheet NineTeams.

To generate a new grouping select sheet Random. Select C2:C21 → Edit → Copy. For OpenOffice, select B2 → Edit → Paste Special → Selection:Numbers (only) → Options:None → Operations:None → ShiftCells:Don't → OK. Sheet NineTeams will have the new groupings.

After selecting B2, for LibreOffice use Edit → Paste Special → Paste Special → Selection etc.  I don't use LibreOffice and didn't test it there.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Randomization in Calc, sections E and J

[imacanuck]

Thank you both, your responses are appreciated.

I was able to come up with a spreadsheet that defined the 20 possible combinations available, then copy and paste the combinations, assign a random number to each pasted row then sort to come up with the 9 random assignments required.

See attached, let me know your thoughts.