Count blanks in Data Validation
I have a spreadsheet that tracks attendance violations by the week. Each day
has a data validation list to select Cancel (CA), No Show (NS), Late (L),
Leave Early (LE) and Violation (V) status.
I would like a formula or code that will check to see if each of the days in
the week were left blank (no attendance violations) and return all the names
of the students with perfect attendance.
Data Validation list is named range: "Attend"
Any help would be greatly appreciated.
|