consecutive cells
This is about Sundays attendance for our members. This is what I want to
accomplish. If a member is absent for 3 sundays consecutively (e.g on
C5=absent, D5=absent and E5=absent, then it will tell me on B5 as "Needs
Follow up". The same thing goes on other columns up to 300. Thanks
|