Addictions
Board Regular
- Joined
- May 27, 2018
- Messages
- 60
- Office Version
- 365
Hello,
I wonder if anybody can help me out.
I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values.
I was able to do this so far with Index, Match and Countif array formula but it only works for one skills column and I cannot figure it out how to do it if there are more skills columns.
Basically if employee has two skills allocated then as a result they would show up on both tables. Please see example of the table below and required results.
<tbody>
</tbody>
<tbody>
</tbody>
Please if somebody can advise I would much appreciate your help.
Kind regards,
I wonder if anybody can help me out.
I am trying to get employees names based on their skills columns and return their names as a result in two different tables as a distinct unique values.
I was able to do this so far with Index, Match and Countif array formula but it only works for one skills column and I cannot figure it out how to do it if there are more skills columns.
Basically if employee has two skills allocated then as a result they would show up on both tables. Please see example of the table below and required results.
A | B | C | |
1 | Employee | Skill 1 | Skill 2 |
2 | Jon | Driver | Mechanic |
3 | Michael | Mechanic | |
4 | Ben | Driver | |
5 | Tony | Mechanic | Driver |
<tbody>
</tbody>
Driver | Mechanic |
Jon | Jon |
Ben | Michael |
Tony | Tony |
<tbody>
</tbody>
Please if somebody can advise I would much appreciate your help.
Kind regards,