Allot Seats to Students based on Choice & Percentage

V

v999

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 th
subjects have to be allotted based on the their percentage. The studen
with a higher percentage gets first preference in the choice he ha
marked ( "1" indicating the subject he is most interested in doing ).

Once can assume there are 4 seats for this for each subject for thi
sample sheet

+-------------------------------------------------------------------
|Filename: Sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=594
+-------------------------------------------------------------------
 
Top