Re: Filter : sort of urgent

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RagDyer (ragdyer_at_cutoutmsn.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 11:18:03 -0700

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!
==============================================
"Keith" <Keith@noemail.com> wrote in message
news:uF3Xb$oPEHA.3140@TK2MSFTNGP11.phx.gbl...
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

Relevant Pages

  • Re: sophie wessex pregnant?
    ... >> the custom of the Realm, just as it was also customary in other lands ... >> wife the surname of the husband, together with his titles and styles. ... there is no need of Letters Patent to make Princess Michael ...
    (alt.talk.royalty)
  • Re: How do I unhide a column?
    ... > Hi Sue, ... titles disappear when you "hide" columns that way. ... (Works only for custom fields) ... >> and unhiding columns in Excel. ...
    (microsoft.public.project)
  • Re: Custom Columns
    ... But when I rename the custom text fields, the new titles won't stick. ... Resource Text1 or Assignment Text1. ...
    (microsoft.public.project)
  • Re: Filter : sort of urgent
    ... You might as well use Custom and contains and just use the string since it ... > Click the "down arrow" in the Titles column, ... > "Keith" wrote in message ...
    (microsoft.public.excel)
  • combo box display
    ... Is there a way to set up a combo box so that when the user clicks the arrow, ... a list of full titles for them to select. ... I want an abbreviation to get put into or displayed in the box. ... So, user opens the list box and sees "A Full Title Is Here", they click on ...
    (comp.databases.ms-access)