HELP-my students want to learn the course from which they will take their termwork

[mehmetics]

---

I have a list which has NAMES (of students), MARKS (for each course), PREFERENCES ( of students - names of the courses) and QUOTA( for each course).
I need an array formula to choose a course for each student by considering the following rules.

1. the student with a lower mark for a course comes first
2. if two or more students have the same marks the smaller preference number (for the same course) has the priority (for the same course)
3. number of studenths for any course can not exceed quota given for each course.

Please help how to attach a sample file

IF YOU HELP, I WILL APPRECIATE YOU.

 

[arthurbr]

Cross post HELP-my students want to learn the course from which they will take their termwork
HELP-my students want to learn the course from which they will take their termwork