search and filter

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

I want to create a search bar or drop down menu that will then lead to only
certain rows being shown.

EXAMPLE:

A5-19 B5-19 C5-19
skills 1-14 rating rating

so if someone were to type in "facilitator" skills 1,5-8,13 and 18 would
show up and the rest would be hidden.

any ideas at all would be great
 
I think you can use VLOOKUP function to return the data you want to from a
hidden sheet .
 
Assuming you have the word "facilitator" in one of the columns, then
apply autofilter to that column. Highlight the cells A4:C19, click on
Data | Filter | Autofilter to turn it on - you will see small arrows
in cells A4:C4. Click on one of these and you will get a list of the
values used in that column, so just select "facilitator" and the rows
which do not contain this word will be hidden.

Hope this helps.

Pete
 
that would work, but some of the 'skills' work for multiple categories (ie.
facilitator and designer) but to use an auto filter only allows me to see one
or the other, not both at the same time.

so what i want it to do is when i type in facilitator, the rows with the
skills that relate to facilitator (whether they also work with designer or
not) are shown and when i type in designer all of the rows with skills that
relate to designer are shown.

????
 
Look at the custom selection of the filter, there you can select both, use

equals facilitator

OR

equals designer


--


Regards,


Peo Sjoblom
 
I need other people to be able to open the document and easily search it. I
need it to be quick, easy and fool proof.
 
Back
Top