Want to use key words to locate essays

[lodtop]

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.

 

[Jezebel]

A spreadsheet seems a strange choice for this. Is there more to the task?
Yes you can search by words in a column, but building and maintaining sets
of keywords is quite a challenge. Why not use one of the freebie search
tools, like Yahoo desktop search?

 

[Biff]

Hi!

Use a filter.

Select the header of the column.

Goto Data>Filter>AutoFilter

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

 

[lodtop]

Thats great and I like the Yahoo Search. But unfortunately I would like
to do this as part of an organization, I would be concerned about
licensing issues and I think the management would not be happy to have
it on our machines.