| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
filtering simply
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simply Accounting | Excel Discussion (Misc queries) | |||
| how do i simply add a check box to a cell? | Excel Discussion (Misc queries) | |||
| how to get excel to simply count the number of red x's | Excel Discussion (Misc queries) | |||
| simply function not work | Excel Worksheet Functions | |||
| can this be done simply ? | Excel Discussion (Misc queries) | |||
Threaded Mode
