I take attendance in large, lecture classes. Each student inputs a vote on a multiple-choice question with a "clicker" (a hand-held, remote control device), and each clicker has a 6-digit, hexadecimal serial number. This semester, I have been placing the attendance data into an Excel spreadsheet (sorting hexadecimal numbers is a nightmare, but that's another story). Due to students' absences, the list of serial codes is different---and has a different size---for different days. Therefore, I have been manually checking off on attendance by visually looking for the same serial numbers.
Can you suggest a way to have Excel automate this process?