Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/11/Randomly-Assign-Name-to-Group.xlsx

In this video I demonstrate how to randomly assign participants to equal sized groups using Microsoft Excel. This video uses some functions that are only available in Excel 365.

Table of Contents:

00:00 - Introduction
00:37 - STEP 1: House the data in an Excel table
01:16 - STEP 2: Create a random number for each participant using RAND
02:01 - STEP3: Rank the random numbers using RANK.EQ
02:23 - STEP 4: Divide the RANK by the group size
02:52 - STEP 5: Round the numbers up using CEILING.MATH
03:13 - STEP 6: Combine formulas into one formula
03:55 - STEP 7: Use the SEQUENCE function to generate group headings
04:45 - STEP 8: Use the FILTER function to list names under the correct group headings
07:43 - STEP 9: Apply conditional formatting
------------------------