Good evening everyone
I am grateful for any help provided
I have a rota table (not actually formatted as an excel table, I would prefer to avoid that).
Column A = employee names
Column B = Shift Start Times
Columns C-Z = Rota patterns, each column is a date.
From this rota table, I need to create a week view of everyone working, highlighted per shift into a printable format that I can distribute. Providing the whole rota view is a bit OTT for the recipient.
This view would be a table headered by dates and start times with the names of the employee populating the body of the table, taken from the rota. As it stands a Rest day is identified in the rota by "R" and by default a blank cell is a working day.
I have tried index match by keep on returning N/A errors.
An example I have used is = index ( NameRange * Match ( 1, (StartTimes = Time ) * ( CalendarDates = Date ) * ( RotaRange = ""), 0 )
To be honest, I don't understand why this approach isn't working for me.
The problem gets a little tricker also because I have 2 people working the same shift on the same day and would need to extract both of their names into the sharable view!
I think one step at a time may be required!
I hope I have made sense.
I have attached a simple example. The top table is the 'working' rota and the bottom table demonstrates the output I am trying to achieve.
Thanks in advance
Bookmarks