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

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 see the attached file.

IF YOU HELP, I WILL APPRECIATE YOU.
THANK YOU EVERYBODY.

Cross post http://www.excelforum.com/excel-general/1052402-help-my-students-want-to-learn-the-course-from-which-they-will-take-their-termwork.html#post3914434
[url]http://www.mrexcel.com/forum/excel-questions/821230-help-my-students-want-learn-course-they-will-take-their-termwork.html
[/URL]