M
masai_chadi
Hello All
I have two sets of data:
- list of Jobs with one or many Competency requirements.
- list of Employees with their Competencies.
I would like to create a filter scheme that allows a user to enter a
Job, and have Excel automatically match Employees with competencies
that are required by the Job.
For example,
Job 'Cashier - Cafeteria' requires two competencies from each employee
working on this Job. So, in this case, there are 4 employees with
these competencies: Employee 4, Employee 7, Employee 8, Employee 9.
Similarly,
Job 'Cleaner' requires 9 competencies from each employee working on
this Job. In this case, there is only one employee with all 9
competencies: Employee 8.
The attached spreadsheet shows the data sets.
How would I achieve this? Thanks.
Masai
Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=455328
I have two sets of data:
- list of Jobs with one or many Competency requirements.
- list of Employees with their Competencies.
I would like to create a filter scheme that allows a user to enter a
Job, and have Excel automatically match Employees with competencies
that are required by the Job.
For example,
Job 'Cashier - Cafeteria' requires two competencies from each employee
working on this Job. So, in this case, there are 4 employees with
these competencies: Employee 4, Employee 7, Employee 8, Employee 9.
Similarly,
Job 'Cleaner' requires 9 competencies from each employee working on
this Job. In this case, there is only one employee with all 9
competencies: Employee 8.
The attached spreadsheet shows the data sets.
How would I achieve this? Thanks.
Masai
Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=455328