Hi all
I have an excel sheet that indicates the timecard date of different employees and I would like to create a table using formulas as opposed to the in-built manual excel function.
My data is unsorted as shown in columns A:D in the attached excel file. The employees can work more than once in day (maximum 3 shifts per day) and more than one employee can work per day.
Column A shows the day.
Column B the employee.
Column C the start of the shift.
Column D the end of the shift.
The goal is to have the date sorted (using formulas) by employee and date, as shown in columns I:N in the attached excel file
Bookmarks