Filtering Out Blanks in a Table

I keep an Excel table of students, their exam scores and when they took the exam. There is a row for each student, with the columns being the various exam grades and the dates they took the exam. I wish to create a list somewhere in the worksheet or workbook of those students that have not yet taken the exam. This list would key upon missing scores in the column. I envsion the created table being similar to what I have, but with a list of the names of those students with blank scores underneath each grade column. I do not want blanks in the list. And I want to be able to print this list out. Plus I would like for the extracted date to update whenever a missing grade is entered. How do I go about accomplishing this?