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?

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"merlin" wrote in message
...
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?

I would have to do it for every request, 24hrs a day 7 days a week. Or, to
do it in advance means doing every combination of skills that might be
required and repeating the exercise everytime someone joins or leaves or
adds a skill to their repertoire (there are 84 people involved).

The only sensible way I can think of is for it to be interactive.

I considered colouring every name white, if it didn't have the requested
skills associated with it but I'm afraid this is beyond me too.

"merlin" wrote in message
...
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?