Tasslehoff
New Member
- Joined
- Nov 8, 2016
- Messages
- 11
Hello there!
A couple of months not touching Excel seem to have dried my brain out and I'm out of ideas.
I have this type of schedule table for around 60 ppl that extends throughout the year.
<tbody>
</tbody>
I need to print out a report that looks like:
<colgroup><col><col></colgroup><tbody>
</tbody>
I know there must be a way with formulas to do this, but I am stuck right now...
thanks in advance for your help!
A couple of months not touching Excel seem to have dried my brain out and I'm out of ideas.
I have this type of schedule table for around 60 ppl that extends throughout the year.
01/01/18 | 02/01/18 | 03/01/18 | 04/01/18 | |
John | A | B | OFF | OFF |
Paul | A1 | B1 | A | B |
George | B | A | OFF | OFF |
Ringo | B1 | A1 | B | B |
Luciano | Training | B | B1 | B1 |
Jose | A | OFF | A | A |
Placido | OFF | A | A1 | A1 |
<tbody>
</tbody>
I need to print out a report that looks like:
01/01/2018 | |
Shift A | |
John | |
Jose | |
Shift B | |
George | |
Shift A1 | |
Paul | |
Shift B1 | |
Ringo |
<colgroup><col><col></colgroup><tbody>
</tbody>
I know there must be a way with formulas to do this, but I am stuck right now...
thanks in advance for your help!