View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Want to use key words to locate essays

Hi!

Use a filter.

Select the header of the column.

Goto DataFilterAutoFilter

From the drop down select Custom
From the first drop down on the left select Contains
From the drop down on the right enter your keyword.
OK

Biff

wrote in message
oups.com...
Basic proposition.

We are trying to use keywords to locate relevant essays.

Could I have a column which includes the keywords and within that
column I could do a search for those rows which possess all the
keywords?

ie

Each essay is allocated keywords by us.

Keywords could be:

speed, engineering, power etc etc etc

Could I then do a search on a column which could include those keywords
(in any order)? The resulting search would only show those relevant
rows.

Hope this makes sense.