Randomly Assign Values to Groups Using Excel 365 or 2021

Do you have values that need to be placed into random groups? For example, assigning participants into experimental groups or splitting employees into groups for a team building event. If so, this video is for you. In this video, we use several of the new functions in Excel 365 and Excel 2021 to build a dynamic equation that randomly assigns a list of values across a list of groups. The equation is flexible enough to automatically reflect changes in your list of values. Thanks for watching. 🎬 YOUTUBE LINKS 🎬 ———————————— Randomly Assign Your Excel Data into Groups: https://youtu.be/SX8x2tLrWEk Randomize Your Data in Excel: https://youtu.be/_upisUsidwQ Work Faster in Excel with These 10 Essential Keyboard Shortcuts: https://youtu.be/H-bHEY1NCF0 ⏱ TIMESTAMPS ⏱ ———————————— 0:00 Introduction 0:38 Assigning Random Numbers 2:05 Assigning Group Numbers 3:22 Assigning Group Names 4:07 Dynamic Participant Count 5:58 Dynamic Groups of Value 7:04 Adding Additional Groups 7:43 Locking Group Assignments 8:17 Wrap up