Hi,
I am trying to cross the info of people, work post and training.
In sheet 1 I have a table which identifies with an X which training the work post needs.
In sheet 2 I have a table which identifies with an X which post each person is able to perform.
Now based on those two tables, I want to automatically create a matrix that combines the info and retrieves me
I am trying to cross the info of people, work post and training.
In sheet 1 I have a table which identifies with an X which training the work post needs.
Post 1 | Post 2 | |
Skill 1 | X | |
Skill 2 | X | X |
In sheet 2 I have a table which identifies with an X which post each person is able to perform.
Post1 | Post 2 | |
Worker 1 | X | |
Worker 2 | X | |
Worker 3 | X | X |
Now based on those two tables, I want to automatically create a matrix that combines the info and retrieves me
skill 1 | skill 2 | |
Worker 1 | X | |
Worker 2 | X | |
Worker 3 | X | X |