Random Groups of 18 with a 50/50 Gender Split

jgonzalez4

New Member
Joined
Jul 17, 2014
Messages
3
I have a list of 360 students that need to be sorted into groups of 18 each. I wish to randomly assign the groups but make each group 50-50 Male/Female. If I have to do two random groups of 9 each by gender that is OK I just don't know how to have excel make random groups of the students in the list.

There is a unique ID for each student in Column A, and their Gender is in Column F.

Any help would be great.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

igold

Well-known Member
Joined
Jul 8, 2014
Messages
2,493
Office Version
365, 2010
Platform
Windows
Why don't you either sort by gender or create a list of each. I would then add a column for the list(s) and in that column insert the function "=rand()" sans quotes and copy down to all cells. You could then sort either A to Z, or Z to A on that column and then take every 9 students as a group. Also every time you hit F9 you can regenerate the random function and resort.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,755
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top