• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Continous Abseetessim

lokhandedeep

New Member
Pl help me with the formula to check the continous absent data in the attendance sheet where in the absence & present is mark in the attendance sheets datewise.
 

Attachments

  • Attendance Tracker.xlsx
    20.2 KB · Views: 7
Scant on detail.
In the same vein:
You're making hard work for yourself; you don't need Sheet2 or helper columns, get the data directly from the Punching Data sheet where:
1. Pivot table taking 30 seconds to produce
2. Table at cell M1 showing consecutive absenteeism (assumes Sundays are to be ignored, so absence Saturday (,Sunday) and Monday = 2 days' continuous absenteeism.
Both tables need to be refreshed if the data in the source table is updated.
 

Attachments

  • Chandoo47220Attendance Tracker.xlsx
    37.6 KB · Views: 6
Hi, Thanks for your reply,

But i am looking for highighting the vaules in the attednance muster sheet 2.

Please help me to highlight the same in sheet2

Thanks,
 
Back
Top