Need Help with Dynamic Attendance Report

xcruc1at3r

Board Regular
Joined
Aug 4, 2011
Messages
50
I need a Attendance Dashboard that reflects the data of people based on their Total Lates
Highest Lates, lates above the given criteria such as 8:30 and above then 9:00 and above then 9:30 and above
and a block where we can search by ID number or name to see the statistics of Administration and Domestic
and Top Three people which Most lates
Can add New Employee as well
and lates at 15:00 hours and above
Attendance Board for management in different block and domestic in different block but on the same page and

I have a Deadline Monday Max 5th of Nov i have uploaded the file as well

EDIT: removed contact information - Moderator
 
Last edited by a moderator:

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,214,833
Messages
6,121,858
Members
449,052
Latest member
Fuddy_Duddy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top