+ Reply to Thread
Results 1 to 7 of 7

Advanced Filter with multiple criteria

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    Tipperary, Ireland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Advanced Filter with multiple criteria

    Hello,

    I'm currently using an Advanced filter to search a spreadsheet for lottery results.

    Each person has 4 numbers and have 3 lines with 4 numbers on each line.

    I have attached the file.

    What I'm trying to do is to filter for people who had 3 number from their 4. I set up the criteria range like below but it doesn't work 100%. The first time I tried it, it worked fine but then some options didn't work. Any help greatly appreciated.
    Last edited by inspiresit; 08-09-2010 at 04:37 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

    Re: Advanced Filter with multiple criteria

    you will have problems as they are all in the same cells and are treated as text strings. the advanced filter is quite precise in what it matches!
    see examples
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    06-15-2010
    Location
    Tipperary, Ireland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Advanced Filter with multiple criteria

    Thanks for that. Maybe I'm being completely stupid but are you saying that it can't be done if they are all in the one cell for the reasons you specified on the attachment. I was aware of the consecutive issue and had tried the wildcards but I was getting something similar.

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Advanced Filter with multiple criteria

    i think someone could right some code that would do this for you

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Advanced Filter with multiple criteria

    I think this advanced filter works.
    Remember what the dormouse said
    Feed your head

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Advanced Filter with multiple criteria

    now thats someone who has too much time on their hands! lol

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Advanced Filter with multiple criteria

    Hey, I've been a forum short for most of the day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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