Building a list of names based on intersections

Say I have a spreadsheet showing constuction workers and the skills they possess:

Name	Paint	Drywall	Carpet
John	Y	N	?
Jane	Y	Y	?
Jim	N	Y	Y
Tim	N	?	N
Tom	?	N	Y

I would like some help figuring out ways to build answers to questions about data in the matrix:

For example:

Give me a list of everyone who can paint:	John, Jane
Give me a list of who needs training in how to Drywall?	John, Tom
What skills information are we missing?	Can Tom Paint? Can Tim Drywall? Can John and Jane Carpet?

Of course, the actual matrix is a hundred people deep and about 100 jobs across... so finding a reliable way to build lists that answer key questions like ones above is really important to how we staff our department.

I've tried using intersect, lookup, and some other funcitons... but can't seem to get the right combination of techniques. I could use some guidance!

Thanks for any help you can provide.

- rocketeer76

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.


On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.


You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.


To upload a file from your computer, click the 'Browse' button and locate the file.


To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.


Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Have you looked at AutoFilter?

Hi Rocketeer,

If you arrange your data in a 2 column format it might be more useful. See the attached where a Pivot Table displays the data. I'm thinking you could filter and sort the data more easily if it were in this format.