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.
Last edited: