Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Attached Files Attached Files

  2. #2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •