How to randomly assign people to teams

Tip: How to randomly assign people to teams

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. 

Duration 
3:49
Author 

Related shortcuts

CtrlT

T

Ctrl

Leave a Reply

Your email address will not be published. Required fields are marked *