Good day,
I am looking for a formula to indicate what training a staff member still has to attend. Below is the training schedule. The T indicates the training they need to attend. The A indicates they have attended the training. What I would like is the list of the staff member that still has to attend training.
below example.
<tbody>
</tbody>
I am looking for a formula to indicate what training a staff member still has to attend. Below is the training schedule. The T indicates the training they need to attend. The A indicates they have attended the training. What I would like is the list of the staff member that still has to attend training.
below example.
Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | ||||||||
2 | 0 | 3 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | |||
Employee Code | T | A | T | A | T | A | T | A | T | A | T | A |
90108226 | 1 | | | | | | 1 | | | | 2 | 0 |
70885239 | | | 1 | | | | | | | | 1 | 0 |
90089568 | | | | | | | | | | | 0 | 0 |
90043158 | 1 | | | | 1 | 1 | 1 | 1 | | | 3 | 2 |
60865961 | | | | | | | | | | | 0 | 0 |
60865986 | | | 1 | | | | 1 | | | | 2 | 0 |
60873999 | | | | | | | | | | | 0 | 0 |
70887266 | | | | | | | | | 1 | | 1 | 0 |
90013032 | | | 1 | 1 | | | | | | 1 | 1 | 2 |
Result | ||||||||||||
90108226 | Course 1 | |||||||||||
70885239 | Course 2 | |||||||||||
90089568 | ||||||||||||
90043158 | Course 1 | |||||||||||
60865961 | ||||||||||||
60865986 | Course 2 | Course 4 | ||||||||||
60873999 | ||||||||||||
70887266 | Course 5 | |||||||||||
90013032 |
<tbody>
</tbody>