Random Groups of 18 with a 50/50 Gender Split

[jgonzalez4]

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.

 

[igold]

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.