Filter : sort of urgent

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have a list of books titles and need to extract the rows that contain the
words "game theory" in them. Does anyone have suggestions on how I can do
this? I am stumped and need this by tomorrow!!

Thanks in advanced!

Keith
 
You could filter the data.
First, select the entire header row of your list.

Then use <Data> <Filter> <Auto Filter>,
Click the "down arrow" in the Titles column, and choose "Custom".

The left box should say "Equals",
In the right box enter
*game theory*
Then <OK>.

You should now have all the rows displayed where your string is part of the
title.

Another option is to place an "X" in a separate column in each row that
would have your string contained in the title.

With the titles in column A, try this starting in row2 of an empty column:

=IF(ISNUMBER(SEARCH("game theory",A2)),"X","")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I have a list of books titles and need to extract the rows that contain the
words "game theory" in them. Does anyone have suggestions on how I can do
this? I am stumped and need this by tomorrow!!

Thanks in advanced!

Keith
 
Keith

Copy the title heading to the top of a column to the right of the data.
Under this heading type ="*game theory*"

Now click any cell in the list and go to Data>Filter>Advanced filter... In
the dialog should be the full extend of your original list. If not ensure
it does. In the criteria box enter the address with your new heading and
the criteria (="*game theory*"). Select copy to a new location and click on
a single cell to the right of your data and the criteria. If there are
likely to be duplicates and this is undesirable then select 'unique records
only' and click OK. Anything with the words game theory anywhere in the
title will appear in this new list. You can now copy and paste wherever you
want.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You might as well use Custom and contains and just use the string since it
will
select that anyway (if you use wildcards once and when you open the custom
again
it will have taken off the ** and changed to contains)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Point well taken Peo.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

You might as well use Custom and contains and just use the string since it
will
select that anyway (if you use wildcards once and when you open the custom
again
it will have taken off the ** and changed to contains)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top