Good morning
I have a challenge that I cannot quite get right.
With the attached sheet as an example, I am trying to extract a summary of "Bagroom" shifts done by various teams and list them seperately for easy reference. The challenge is that some teams will have no bagroom component, some have 1 shift in the bagroom, and others have 2 shifts. These are highlighted in purple in the data.
To the right is my desired outcome:
- where a team has no bagroom shift, leave it blank (eg LC8)
- Where a team has one bagroom shift place the task start and task finish times in columns N and O.
- If a team has a second bagroom shift, place the task start and task finish times in columns P and Q.
The pasrt i am finding difficult is matching the Team name (LC7 etc) to the bagroom component only in that team.
Any assistance would be greatly appreciated.
Thanks in advance
Darren
Bookmarks