I'm a teacher and I have a record of student absences like this:
Name Nov. 4 Nov. 5 Nov. 6 Nov. 7 Divine absent present absent late Riza absent present absent absent Aira absent absent absent absent
In their summary records, I want two different pieces of data: number of absences (simple countif) and number of occurrences, wherein if it's consecutive, it's counted as one.
For example, Divine would have an A of 2 and an O of 2. Riza would have an A of 3 and an O of 2. Aira would have an A or 4 and an O of 1.
Any macro or formula is much appreciated.
Thanks!
Bookmarks