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.

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?




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.

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.

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.