+ Reply to Thread
Results 1 to 5 of 5

Advanced Filter

  1. #1
    Registered User
    Join Date
    08-16-2004
    Posts
    34

    Advanced Filter

    Hi I'm trying to use the advance filter for multiple criteria in one column. It works fine if the criteria is ="*10*" (ie where the cell in the range has 10 in the string) plus other = criteria

    What I cannot get to work is where the range doesn't equal 10 in the string.

    I've tried ="<>*10*" and other variations to no joy.

    Is this possible?

    Cheers, Teeb
    Last edited by teeb; 10-06-2008 at 09:36 AM.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    cant you just use autofilter does not contain 10

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,579
    You'll need to put the entire expression in quotes
    Please Login or Register  to view this content.
    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    08-16-2004
    Posts
    34
    Quote Originally Posted by ChemistB View Post
    You'll need to put the entire expression in quotes
    Please Login or Register  to view this content.
    Does that work for you?
    Thanks for this ChemistB! Works Perfectly.

    My next problem I have come accross is that I have 5 columns with percentages in them. What I'm trying to get is to add anoter filter command that will look at all the five columns and leave me with any row where any of the five columns have a figure >100%.

    If I do this as a separate filter under each column I get no data, which makes sense as none of the rows have all the data >100%.

    Any extra help would be appreciated.

    Thanks, Teeb

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,579
    You'll need to use the advanced filter. Take a look at it under the Excel help files. If each entry is in a separate row, the advanced filter uses looks at them as OR. If they are in the same row, then it treats the criteria with AND.

    ChemistB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Advanced filter with function as criteria range?
    By dakke in forum Excel General
    Replies: 23
    Last Post: 06-10-2021, 04:48 PM
  2. Disabling the Advanced filter function
    By ngk08 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2016, 06:15 PM
  3. Advanced filter doesn't work on cell links?
    By matt99b in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-10-2008, 12:41 PM
  4. Advanced Filter + Several Macros
    By excel_owns_me in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2007, 02:52 AM
  5. Advanced Filter: Having some trouble
    By globulous in forum Excel General
    Replies: 3
    Last Post: 06-04-2007, 03:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1