How to randomly assign people to teams
In this video we’ll look at a basic way to randomly assigning people teams.
Here we have a list of 36 people.
Let’s say we want to randomly assign each person to a team of 4 people, so that we have a total of 9 with 4 people in each.
I’m going to solve this problem in small steps, with helper columns, then bring things together in the end. This is a great way ot solve more complicated problems in Excel.
I’ll start off with an Excel Table, to make the formulas very fast to enter.