Hello experts,
At my school we need a script/formula to automize a selection procedure. Students have to hand in 4 preferred schools and they also need to mentioned whether they want to start in autumn of spring.
Conditions:
Based on the rank (column F) the student with the highest score will be awarded with his first preferred choice. This first choice will have to be the input for e.g. cell M1. Along the process the script of formula also has to double check if there are still places available (L18:J25). In case there are no place available at a particular school, the script of formula should automatically select the second (or third or fourth) preferred school if there are still places available ....and so on.
If there are no (1st, 2nd, 3rd or 4th preferred) places available anymore in relation to the preferred school, the text "no preferred place" should be displayed.
Who can help me with this problem?
Greetings, Remko
At my school we need a script/formula to automize a selection procedure. Students have to hand in 4 preferred schools and they also need to mentioned whether they want to start in autumn of spring.
Conditions:
Based on the rank (column F) the student with the highest score will be awarded with his first preferred choice. This first choice will have to be the input for e.g. cell M1. Along the process the script of formula also has to double check if there are still places available (L18:J25). In case there are no place available at a particular school, the script of formula should automatically select the second (or third or fourth) preferred school if there are still places available ....and so on.
If there are no (1st, 2nd, 3rd or 4th preferred) places available anymore in relation to the preferred school, the text "no preferred place" should be displayed.
Who can help me with this problem?
Greetings, Remko
