I have three data tables (see below).
What I need to do is populate the tables below these (A17:E23and A26:E32). I.e. for line one Mondaymanning I need to pull in the names of the people working in each role.
I think it may be some form of index and match formula Iwould need but I can’t figure it out for the life of me. Can anyone help?
Thanks!
<colgroup><col width="156" style="width: 117pt; mso-width-source: userset; mso-width-alt: 5705;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" span="5"> <col width="64" style="width: 48pt;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="7"> <col width="64" style="width: 48pt;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" span="7"> <tbody>
</tbody>
- The first one (A1:H12) shows the employee name and whether they are in work on a given day
- The second one (J1:P12) shows what job role they are working on a given day
- The third one (R1:X12) shows what line they are working on
What I need to do is populate the tables below these (A17:E23and A26:E32). I.e. for line one Mondaymanning I need to pull in the names of the people working in each role.
I think it may be some form of index and match formula Iwould need but I can’t figure it out for the life of me. Can anyone help?
Thanks!
LINE ROLE | LINE | ||||||||||||||||||||||
Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | ||
John A | |||||||||||||||||||||||
John B | W | W | W | W | Job 1 | Job 1 | Job 1 | Job 1 | 1 | 1 | 1 | 1 | |||||||||||
John C | W | W | W | W | W | Job 1 | Job 1 | Job 1 | Job 1 | Job 1 | 2 | 2 | 2 | 2 | 2 | ||||||||
John D | W | W | W | W | W | Job 2 | Job 2 | Job 2 | Job 2 | Job 2 | 1 | 5 | 1 | 1 | 1 | ||||||||
John E | W | W | W | W | Job 2 | Job 2 | Job 2 | Job 2 | 1 | 1 | 1 | 1 | |||||||||||
John F | W | W | W | W | W | Job 3 | Job 3 | Job 3 | Job 3 | Job 3 | 1 | 1 | 1 | 1 | 1 | ||||||||
John G | W | W | W | W | W | Job 3 | Job 3 | Job 3 | Job 3 | Job 3 | 1 | 1 | 1 | 1 | 1 | ||||||||
John H | W | W | W | W | W | Job 3 | Job 3 | Job 3 | Job 3 | Job 3 | 1 | 1 | 1 | 1 | 1 | ||||||||
John I | W | W | W | W | W | Job 4 | Job 4 | Job 4 | Job 4 | Job 4 | 1 | 1 | 1 | 1 | 1 | ||||||||
John J | |||||||||||||||||||||||
Line 1 manning - Monday | Headcount | Employees | |||||||||||||||||||||
Job 1 | 0 | ||||||||||||||||||||||
Job 2 | 2 | John D | John E | ||||||||||||||||||||
Job 3 | 2 | John F | John H | ||||||||||||||||||||
Job 4 | 0 | ||||||||||||||||||||||
Line 2 manning - Tuesday | Headcount | Employees | |||||||||||||||||||||
Job 1 | 0 | ||||||||||||||||||||||
Job 2 | 1 | John E | |||||||||||||||||||||
Job 3 | 3 | John F | John G | John H | |||||||||||||||||||
Job 4 | 1 | John I | |||||||||||||||||||||
<colgroup><col width="156" style="width: 117pt; mso-width-source: userset; mso-width-alt: 5705;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" span="5"> <col width="64" style="width: 48pt;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" span="7"> <col width="64" style="width: 48pt;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" span="7"> <tbody>
</tbody>
Last edited: