Creating groups based on priorities

Hi all,

I work as a teacher, and we have our annual theme-week coming up, where we mix students from all years together across 20 activities.

The students get to prioritize all these activities. Prior years they have (from what I hear) then made the teams manually. I figured that automating it could both make it faster, and better.

I have managed to convert all test-set of the data so it is easily handled. But I am not sure how I get excel to start dividing the students onto the different activities.

Ideally, the activities have different constraints in terms of group sizing too.

Does anyone have any ideas?