View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Boogie Boogie is offline
external usenet poster
 
Posts: 8
Default 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