I use excel as register to tally attendance in lectures and tutorials. We
have been requested to send an e-mail to a personnel tutor of students if the
student fails in attending two consecutive sessions. We enter attendance as
either a 1 or a 0 in a horizontal row. I want to automate a response so any
students name is generated who gets two consecutive 0. I could then cut and
paste this into an email. I would like this not to interfere with a formula
to give a final attendance total and the end of the row.
I use Microsoft EXcell 2002-SP-2
Please can anyone help? I may have some time to get down to more important
things such as teaching if I can remove this type of time consuming task.