00:00want to see the most efficient way to take attendance and at the same time dynamically
00:03update attendance summary like this here's how you do it i've got an attendance sheet with student
00:08name and i've got a check box indicating the attended status here and if you right click on
00:13check box you go format control each check box is associated with the cell where it is located so
00:18that i can display the status of the check box like this you can see if i put a check
00:22here it's
00:23true and we remove the check is false you get a list of attended student you're going to use a
00:27filter function the first argument on the filter function will be the student name comma the
00:31second argument will be the attended status equal to true if you get a calc error here you're going
00:37to have to encapsulate the filter function with an if error function and if it's an error the second
00:42argument of if error function will be blank you're going to copy the same formula for absentee
00:48and basically change the true to false and then for cosmetic reason you can change the font color on
00:54attendant here to white so that it doesn't appear and then you're done
Comments