I have 120 students. They need to be placed into 8 groups. Those groups need to be created based on their gender and their preference for whom they would like to be with ie Jane was asked and would prefer to be in a group with 1st Edith J, 2nd Fiona, 3rd Jenny M. How can I do this using Excel?
Bookmarks