lets say I have information of workers working on different items, some items are made with multiple workers. And there are start date and end date as shown in the table below.
Here is the result I would like to achieve using a formula.
This is so I can check when each worker will be done with their tasks.
start date | end date | workers |
1 jan 21 | 10 feb 21 | A + B |
11 feb 21 | 20 feb 21 | B |
11 feb 21 | 1 mar 21 | A + C |
2 mar 21 | 15 apr 21 | C |
Here is the result I would like to achieve using a formula.
Worker | end date |
A | 1 mar 21 |
B | 20 feb 21 |
C | 15 apr 21 |