amanpareek
New Member
Hello,
I work as an HR and have to get along with the attendance of people working.
During the Month-end I have to figure out Maximum continuous Not Marked Attendance for employees.
Below is an example of the same:
Is there any way that I can populate the Maximum Consecutive Not Marked in Last cell of given Range.
Thanks in Advance.
I work as an HR and have to get along with the attendance of people working.
During the Month-end I have to figure out Maximum continuous Not Marked Attendance for employees.
Below is an example of the same:
01-09-2019 | 02-09-2019 | 03-09-2019 | 04-09-2019 | 05-09-2019 | 06-09-2019 | Count of Max. Consecutive not marked. |
Present | Not Marked | Not Marked | Not Marked | Absent | Not Marked | 3 |
Is there any way that I can populate the Maximum Consecutive Not Marked in Last cell of given Range.
Thanks in Advance.