Want to use key words to locate essays

  • Thread starter Thread starter lodtop
  • Start date Start date
L

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.
 
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?
 
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
 
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.
 
Back
Top