Abhilasha Awasthi
New Member
- Joined
- Aug 8, 2011
- Messages
- 14
Hi I have two reports to check the attendance, one is attendance tracker which we update manuualy in excel. In coloumns headings are names, dates (for example, column A has name, b has 1st march, c has 2nd march and so on.) row waise it has absent, priveledge leave or sick leave.
Report 1:
Column A 03/01/2018 03/02/2018 03/03/2018 03/04/2018 ........... 03/17/2018
Name ABC Present Privilege Leave Present Present Present
Name XYZ Present Present Present Sick Leave Sick Leave
in other report which is through a tool, it given what leaves an associate has applied on tool. and this data in excel comes out as ...
Report 2:
Column A Column B Column
Name Abc Privilege Leave 3/2/2018
Name XYZ Sick Leave 03/4/2018
I need a report which can reconcile these two reports and tell the difference. for example XYZ was on sick leave on 17th March but has not marked in tool (since tool report is not showing his data for 17th march)
Report 1:
Column A 03/01/2018 03/02/2018 03/03/2018 03/04/2018 ........... 03/17/2018
Name ABC Present Privilege Leave Present Present Present
Name XYZ Present Present Present Sick Leave Sick Leave
in other report which is through a tool, it given what leaves an associate has applied on tool. and this data in excel comes out as ...
Report 2:
Column A Column B Column
Name Abc Privilege Leave 3/2/2018
Name XYZ Sick Leave 03/4/2018
I need a report which can reconcile these two reports and tell the difference. for example XYZ was on sick leave on 17th March but has not marked in tool (since tool report is not showing his data for 17th march)