Criteria in Advanced Filter

[Christine]

Please tell me how to extract records in a certain range.
I need to have all rows where date is from 3 to 8 for
example. I'm using Advanced filter and 2 rows for
criteria. When I enter data in the 2 rows for given
column, I have and OR condition. I need an AND condition.

 

[Leo Heuser]

Christine

If you want an OR condition, you would have
the criteria range in e.g. L1:M3 with

Head1 Head2
a
b

For an AND condition use e.g. criteria range
L1:M2 and

Head1 Head2
a b

 

[Debra Dalgleish]

You can use the Date heading twice in the criteria area, with >Date1 and
<Date2 as the criteria, in the same row. There's an example here:

http://www.contextures.com/xladvfilter01.html#Criteria