Hi Everyone,
I have a situation where I'm trying to work out class groups for students based on their English, Maths and Science scores.
I have made a table which explains the system, whereby a student's level (1,2 or 3) are considered and a group number is given.
i.e. Student 1001 scored level 1 in English, level 2 in Maths and level 3 in science, so therefore the system (table) shows that they should be placed in group 1 (see attached).
Essentially I have a matrix of numbers used for reference with three levels. And if certain conditions are satisfied, it gives out a different group number at the end.
It's important to say that there is no calculation involved at all. The system needs to just look at column a for a number, then column B, then column C and display the value that satisfies all those conditions.
Attached is an example of the system.
I know I haven't been completely clear in my post, ,however it should make sense when the attachment is viewed.
Class Set Sorting System.xlsx
Bookmarks