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

Timecard.xlsx (176.6 KB, 12 views)