Advanced Filter: Problem with Multiple AND/OR Criteria

**excelnewbie80** · 06-18-2012, 04:09 AM

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.

**outofthehat** · 06-18-2012, 07:48 AM

You have to specify the full set of criteria in each row. Your current criteria state "US Good within the dates" or "EU bad - any date" or "AP any date".
Therefore if you want the date criteria to apply to each of the rows, you need to duplicate it in each row

Date	       Date	   Region	    Type
>=1/1/2012    <=2/2/2012     US	        Good
>=1/1/2012    <=2/2/2012     EU	         Bad
>=1/1/2012    <=2/2/2012     AP