I would love some assistance with the following problem.
Each year for school camps we take the students preferences 1-6 of who they'd like to bunk in with for the week. We usually sort this out manually, but there has to be a much quicker way to do it using Excel. (Is this a marriage problem?- I just read about it on this site)
+Each student should have at least one preference- preferably their top 3 but not necessarily.
+The problem is that some students aren't chosen by anyone else, but they must still be placed with another student of their choosing.
+There are rooms for 4, 6 and 8 students to a room. (Make it clear in the spreadsheet where this information can be changed based on the quantity of rooms that sleep 4 or 6 o 8)
+Although the image shows 26 possibilities of the preferences as given by students, there are actually 104 students.
+I want to be able to reuse the spreadsheet for the students of the opposite genders.
The following spreadsheet displays a sample.