Hi there,
Assume that there is an exam and students want to register their choices (departments).
It needs creating such an excel file that can assign students to their choices (A, B, C, D & E) considering/according to scores of them.
There are approximately 300 students and the capacities of groups for winners and backups/reserves for each choice are the same.
They are as follow:
# of winners for each choice: A = 30, B = 15, C = 15, D = 15 & E = 15
# of reserves for each choice: F = 30, G = 15, H = 15, I = 15 & J = 15
Each student should be in just one choice list, or its related reserves.
Now, I wonder, which properties of Excel (functions, macros etc) do I need to know and use?
And where can I find their videos or documents about how to do?
Thank you very much for your time and efforts.
Assume that there is an exam and students want to register their choices (departments).
It needs creating such an excel file that can assign students to their choices (A, B, C, D & E) considering/according to scores of them.
There are approximately 300 students and the capacities of groups for winners and backups/reserves for each choice are the same.
They are as follow:
# of winners for each choice: A = 30, B = 15, C = 15, D = 15 & E = 15
# of reserves for each choice: F = 30, G = 15, H = 15, I = 15 & J = 15
Each student should be in just one choice list, or its related reserves.
Now, I wonder, which properties of Excel (functions, macros etc) do I need to know and use?
And where can I find their videos or documents about how to do?
Thank you very much for your time and efforts.
