Results 1 to 7 of 7

Advanced Filter with multiple criteria

Threaded View

inspiresit Advanced Filter with multiple... 08-09-2010, 04:18 AM
martindwilson Re: Advanced Filter with... 08-09-2010, 07:24 AM
inspiresit Re: Advanced Filter with... 08-09-2010, 09:46 AM
martindwilson Re: Advanced Filter with... 08-09-2010, 11:47 AM
romperstomper Re: Advanced Filter with... 08-12-2010, 10:09 AM
martindwilson Re: Advanced Filter with... 08-12-2010, 11:19 AM
romperstomper Re: Advanced Filter with... 08-12-2010, 11:21 AM
  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.

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