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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,974
Messages
5,856,600
Members
431,823
Latest member
irtezazaz

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
Top