Allot Seats to Students based on Choice & Percentage

[kharsang]

Hello,

I would be very glad if someone could help me on this.

I have attached a sample sheet wherein there are students to whom the subjects have to be allotted based on their percentage. The student with a higher percentage gets first preference in the choice he has marked ( "1" indicating the subject he is most interested in doing ).

One can assume there are 4 seats for this for each subject for this sample sheet.

How to generate an excel sheet containing a list of all the selected students with their allotted choice of subject?


Thanks

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Allot Seats to Students based on Choice & Percentage (REPOST from another member)
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.