Grouping People On Preference

WOW, that was quick.

Would the use of Solver still be required if the preferences were not weighted? I think weighting the preferences would be ideal in a digital world but may just complicate things for her. If possible, I would like to see a simpler sheet with no weights and the maximum number of preferences limited to three but could be modified for one max or two max preferences.

I will ask her how many campers actually submit cabin mate requests. This number could be much lower than I imagined so a free version may be adequate. One more thing I forgot to mention is the number of possible combinations are only half of what you thought them to be since cabin mates are always of the same gender.

Thanks again!

Hi all, I have a similar question and i think this solver feature will help me. I am hosting a think tank and each participant will select 3 people they want to work with on future collaborative projects. I have downloaded the camper assignment but unfortunately, I'm only somewhat savvy with excel. Can some please please kindly give me a more step by step instruction on how to group the participants into groups of 3 or 4. I will have about 30 participants in total. Thank you.