View Single Post
 
Old 07-27-2019, 07:56 AM
aligahk06 aligahk06 is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default Employee number according to timetable sequence

Dear All,

I want my attached excel file in following order.
1. Column D consist time table name.

I want this time card in order of timetable name irrespective of employee sequence.
i.e all employee who has 06:00 - 14:00 timetable appear first then all employee who has timetable 07:00 - 15:00 appear next and 08:00 - 16:00 and then 08:30 - 17:30 and so on.

It help me to trace out how many employee attached with each timetable in sequence.
Attached file for ref. Any help deeply welcome.
solution needed....


Rgds,
aligahk06
Attached Files
File Type: xlsx Timecard.xlsx (176.6 KB, 10 views)
Reply With Quote