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.
Bookmarks