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
Job, and have Excel automatically match Employees with competencie
that are required by the Job.

For example,

Job 'Cashier - Cafeteria' requires two competencies from each employe
working on this Job. So, in this case, there are 4 employees with thes
competencies: Employee 4, Employee 7, Employee 8, Employee 9.

Similarly,

Job 'Cleaner' requires 9 competencies from each employee working o
this Job. In this case, there is only one employee with all
competencies: Employee 8.

The attached spreadsheet shows the data sets.

How would I achieve this? Thanks.

Masa

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=45654
--
Message posted from http://www.ExcelForum.com