This will be my first question here, so sorry if I break any sort of etiquette. I have set up an attendence tracker that allows me to mark each employee with a status each day: Working, Sick, Half Day, Annual Leave and so on.
I would like to count their periods of absence. I know how to use count, countif and countifs, but I can't figure out how to do this. Example:
Absent on monday, present tuesday, absent wednesday and thursday, present friday. This would be 2 periods of absence.
Absent monday - friday. This would be 1 period of absence.
I'm essentially trying to group identical adjacent cells so that they only get counted by my formula once. Is this possible?
Any help would be much appreciated.