Hey all,
So I'm a teacher and I'ver created an attendance sheet for my classes in Numbers using checkboxes. I was wondering is there a way to get Numbers to list all the students that were not checked as present?
MacBook Pro (Retina, 15-inch, Late 2013), OS X Mavericks (10.9.1)
You can do something like this:
Column A counts those who are absent based on the checkboxes in column C. Then column E creates a list of the absent kids.
A2=IF(C2=FALSE,MAX($A$1:A1)+1, "")
this is shothand for, select cell A2, then type (or copy and paste from here) the formaula:
=IF(C2=FALSE,MAX($A$1:A1)+1, "")
select cell A2, copy
select column A to select the column, then hold the command key and click cell A1 to unselect cell A1
paste
E2=IF((ROW()−1)≤MAX(A), VLOOKUP(ROW()−1, A:B, 2, 0), "")
select E2 and fill like before
Also, in case you haven't seen it, the Attendance template may give you a good starting point for what you want to do.
File > New and select it in the Education section:
You could change it to have Date across the top, and Students down column A. Then just filter for FALSE:
SG
Attendance Summary
