Randomly Assign Your Excel Data into Groups

In this video, we explore multiple ways to generate random group assignments for our data. We will start with a shorter solution that requires two columns, but can cover any number of items in your data column. Next, we build a static, single-column solution that’s great when you know the number of datapoints. Lastly, we expand the single-column solution to end up with a single-column equation that can flex with the number of rows.

TIMESTAMPS:
====================
0:00 Introduction
0:20 Outline
1:14 Solution 1
4:07 Solution 2a
9:46 Solution 2b
12:42 Summary
12:42 Wrap up

EXCELSMITH LINKS:
====================

MICROSOFT LINKS:
====================

UNSPLASH IMAGE:
====================
Photo by Mitchell Luo on Unsplash

[JCEurovisionFan]

How can I randomly assign data into groups for those who have Excel 365 and Excel 2021?

[apekshasamyal]

I have assigned people in group. What if one of the person gets in either group i want to highlight how do you do

[wat_herbivore]

good explanation but can't see your functions.