Hi, so I am a teacher and I am using a program socrative which allows my students to answer questions and then it collates all the answers together, giving me a percentage out of 100 at the end. I then request the information from the students answers in a excel spreadsheet.

I have set up a master sheet to keep track of all this data, but I get about 3 to 5 spreadsheets a day from different classes.

My main issue is that one day I might have 50 students attend my lecture, but the following lecture (same class), only 38 attend. I want to take this data and input it into my master sheet, but this data always comes in a different order and unsorted.

What I want to do is to drop this unsorted data into my master sheet, and then for excel to match up the data to the correct student, and realise which student had not attended the lecture, therefore giving them a score of Zero.

I have been racking my brain for a few days over this and hope someone could guide me in the right direction.
kind regards