I'd add another column for each week. Then put this kind of formula in it:

=COUNTIF(A2:E2,"<")
(and drag down)
Where A:E is a 5 day week.

Then apply data|filter|autofilter to that column.

Filter to show the 0's and you'll have the kids with perfect attendance.

You could also count individual violations:
=countif(a2:e2,"L")
would count the Late's.



clarknv wrote:

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.

--

Dave Peterson