Re: search and filter

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.

"Peo Sjoblom" wrote:

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

equals facilitator

OR

equals designer


--


Regards,


Peo Sjoblom


"Jenny" <Jenny@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:84601AAD-E789-4B26-9259-936C5FA04F3F@xxxxxxxxxxxxxxxx
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.

????

"Pete_UK" wrote:

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

On Nov 26, 9:35 pm, Jenny <Je...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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





.

Relevant Pages

  • Re: search and filter
    ... Look at the custom selection of the filter, there you can select both, use ... facilitator and designer) but to use an auto filter only allows me to see ...
    (microsoft.public.excel.worksheet.functions)
  • Re: News: Breast cancer gene-free baby due.
    ... I don't think this technology leads towards designer babies, ... Deaf parents have tried to choose to have deaf ... but are compensated by having/developing other skills. ... foundation of disability discrimination law, ...
    (talk.origins)
  • Re: News: Breast cancer gene-free baby due.
    ... interview on Radio 4 the other day and he said it was not designer ... but are compensated by having/developing other skills. ... Build environment, of course, - I'm not IDler, when I use the word ... foundation of disability discrimination law, ...
    (talk.origins)
  • Designer Needs to Learn More. Where?
    ... I am a part time contract PCB designer. ... as balanced lines and controlled impedance, ... skills that I have fallen behind on. ... with the idea of multiple, split planes, cost me opportunities, because ...
    (sci.electronics.cad)
  • Re: News: Breast cancer gene-free baby due.
    ... interview on Radio 4 the other day and he said it was not designer ... babies as all they could do was weed out genetic problems. ... once you think about it): You assume that being deaf ... but are compensated by having/developing other skills. ...
    (talk.origins)
Quantcast