General discussion

Locked

Filtering Out Blanks in a Table

By cccgsmith ·
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?

This conversation is currently closed to new comments.

12 total posts (Page 2 of 2)   Prev   01 | 02
Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
12 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums