Hi guys
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:
Sick Periods.xlsx
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.
Thanks,
Robert
Bookmarks