3 Replies Latest reply on May 8, 2018 9:40 AM by Ashan Bogollagama

    How to count consecutive blanks in a row

    Ashan Bogollagama

      Hi,

      I have a workbook (below) that counts a members attendance to an annual meeting. If attended there is a designated 1 for that year. Is it possible to count the number of consecutive blanks or gaps between attendance?

      I would like to determine if there are any trends in gap years.

       

      Thanks,

      Ashan