D
dstdst123
Hi
I have 16 female, 4 male students.
All these 20 students comes from different majors.
12 Physic, 4 Chemistry and 4 Biology.
I want to group them into 4 teams (each team 5 students).
Priority #1:
To ensure at least 1 male student assigned to each team
Priority #2:
Distribute them equally between Physic, chem, and biology
(i.e. each team should have a mix of majors)
Questions:
1) Do I need to write programmes in Excel 2003?
2) Can pivot table help? How to do it in my case?
Thanks a lot.
dstdst123
I have 16 female, 4 male students.
All these 20 students comes from different majors.
12 Physic, 4 Chemistry and 4 Biology.
I want to group them into 4 teams (each team 5 students).
Priority #1:
To ensure at least 1 male student assigned to each team
Priority #2:
Distribute them equally between Physic, chem, and biology
(i.e. each team should have a mix of majors)
Questions:
1) Do I need to write programmes in Excel 2003?
2) Can pivot table help? How to do it in my case?
Thanks a lot.
dstdst123