Assign RANDOM Groups in Excel (WRAPROWS + RAND Formula Trick)

Description:
???? Assign Random Groups in Excel in Seconds (WRAPROWS + RAND Trick)

Need to randomly assign employees, students, or participants into groups in Excel? In this video, I’ll show you two powerful methods using modern Excel formulas that automatically create groups with zero manual work.

Whether you're organizing team projects, training sessions, workshops, or classroom activities, this technique will instantly generate balanced random groups.

???? Method 1 – WRAPROWS + RAND() (Step-by-step approach)

✦ Formula used:
=WRAPROWS(B9:B20,3)

✦ What it does:
This formula takes a single column list of names (B9:B20) and arranges them horizontally into rows of 3 people per group.

✦ How randomness is added:
Before using WRAPROWS, the list can be randomized using the RAND() function. RAND() generates random numbers that can be used to shuffle the list. Once the list is randomized, WRAPROWS simply breaks that randomized list into groups.

✦ Example use case:
• Assigning employees to workshop groups
• Creating random student teams
• Organizing participants in breakout sessions

???? Method 2 – Fully Automated Random Group Generator (Advanced Formula)

✦ Formula used:
=WRAPROWS(SORTBY(B9:B20,RANDARRAY(ROWS(B9:B20))),3)

This formula automatically shuffles and groups your list in one step. Let's break it down:

✦ ROWS(B9:B20)
Counts how many names are in the list so Excel knows how many random numbers to generate.

✦ RANDARRAY(ROWS(B9:B20))
Creates a column of random numbers equal to the number of names in the list.

✦ SORTBY(B9:B20,RANDARRAY(...))
Sorts the list of names based on those random numbers, which effectively shuffles the entire list randomly every time the worksheet recalculates.

✦ WRAPROWS(...,3)
Finally, WRAPROWS takes the randomized list and places the names into rows of 3, instantly forming groups.

⚡ Result:
One formula that randomizes AND assigns groups automatically.

???? Why this method is powerful

✦ No manual sorting
✦ No helper columns required
✦ Groups update instantly
✦ Perfect for HR, teachers, trainers, and event organizers

???? ESSENTIAL LINKS
???? Support my work:
https://buymeacoffee.com/mehranvahedi
???? Explore my Skillsoft courses:
https://linktr.ee/MySkillsoftCourses
???? Book a personal mentoring session:
https://topmate.io/mehran_vahedi
???? Follow for daily insights:
https://x.com/WisdomByData
???? Connect professionally on LinkedIn:
https://www.linkedin.com/in/mehranvahedi

???? TAGS (for YouTube tag section)
excel random groups, assign random groups excel, excel wraprows tutorial, random teams excel, excel randarray example, excel sortby formula, excel wraprows function, random assignment excel, excel group generator, excel tips and tricks, excel formulas tutorial, excel for hr managers, excel randomize list, assign employees to groups excel, excel modern functions, excel productivity tips, excel dynamic array formulas, excel tutorial