Results 1 to 3 of 3

Advanced Filter: Problem with Multiple AND/OR Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    19

    Advanced Filter: Problem with Multiple AND/OR Criteria

    Hi,

    I am having problems using Advanced Filter for my data. I cant seem to get my criteria right.

    Sample Data:

    Number	Product	Region	Date	    Type
    1            Test1     US         01/01/12     Good
    2            Test2     EU         02/02/12     Bad
    3            Test3     AP         05/05/12     Bad
    4            Test4     AU         05/05/12     Bad

    Criteria I want
    Date between 01/01/12 to 02/02/02 AND regions (either US or EU or AP) AND type (either good or bad)

    Based on this criteria, result should be:
    
    1            Test1     US         01/01/12     Good
    2            Test2     EU         02/02/12     Bad
    Here's what i entered as criteria

    
    Date	       Date	   Region	    Type
    >=1/1/2012    <=2/2/2012     US	        Good
    		             EU	         Bad
    		             AP
    The result I got was that the region AP was also included even though it did not meet the date criteria.
    Last edited by excelnewbie80; 06-18-2012 at 09:00 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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