filtering simply

[merlin]

I have a sheet which looks like this (in reality there are 84 names by
around 30 skills):

person skill 1 skill 2 skill 3
tom yes
barbara yes
gerry yes
margo yes yes yes

view staff with which skill?..........

I want to offer a box to allow the user to choose a skill and be given a
list of the staff that have that skill. In the example, 'skill 1' should
return:
tom
margo

and 'skill 2' should return:
barbara
margo

etc

Even better would be to allow combinations of skills, such as skill 1 and
skill 2 which should return just 'margo'

the sheet is for use by very basic users and I can't expect them to apply a
filter - ideally I'd just like them to be able to click on a box or choose a
skill or skills from a pull down box.
I can't use VBA either so I need a normal non-VBA solution.

Any thoughts?

 

[Don Guillett]

Why don't YOU apply the filter and let the user select from choices?