Excel 2007 : Create a table that lists blank cells

[cathzee]

Hi.

I have a table (see attached file) that shows the sample students and their scores for each homework, class work, project, and quizzes. Some of the students have blank cells. How can I pull out/create another table that will only show the list of students who missed any work? The file attached also shows the other table that I want to create. I don't want to manually look for the blank cells on the table.
Any help would be greatly appreciated.