Hi everyone,
I need to find out when was the last time a person did a task.
It sounds easy but due to the way the data is displayed, I am unable to sort it out.
Here you have an example of it:
<tbody>
</tbody>
Solution would be:
Worker 1
Task A: 29/09
Task B: 25/09
Task C: 27/09
Task D: 28/09
And so on...
Thanks for your help!
I need to find out when was the last time a person did a task.
It sounds easy but due to the way the data is displayed, I am unable to sort it out.
Here you have an example of it:
Name | 23/09 | 24/09 | 25/09 | 26/09 | 27/09 | 28/09 | 29/09 |
Worker 1 | A | B | B | A | C | D | A |
Worker 2 | B | B | C | D | D | A | B |
Worker 3 | C | C | C | D | D | A | B |
Worker 4 | A | A | C | D | B | A |
<tbody>
</tbody>
Solution would be:
Worker 1
Task A: 29/09
Task B: 25/09
Task C: 27/09
Task D: 28/09
And so on...
Thanks for your help!
Last edited: