Advanced Filter Issue

  • Thread starter Thread starter michaelburkett
  • Start date Start date
M

michaelburkett

For some reason I can not get the criteria right for this...any help
mound be appreciated.

Field1 Field1 Field2
=12/31/05 <=3/31/06 >=3/31/06
Click to expand...

I am trying to filter all records in the between the two dates in
field1 AND the records must also have a date greater than field2.

It works perfect when I the criteria is on the 2 Field1 criteria but it
does nothing when I add Field2 to the criteria.

Ideas?
 
Do you have 2 date columns so that you want to filter the dates in one
column that is between Jan 1 AND Mar 31 AND the dates in a second column
that is greater than Mar 31. Then your criteria works.
It obviously won't work for one column of dates but for 2 yes it does work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I join 2 fields to limit criteria? 1
Add the monthly range in each row using the actual start and end d 4
Counting Cells with Multiple Range Criteria (Excel 2003) 7
mandatory field size within table 5
Update Query question 2
Excel Advanced filter - Filtering using dates 6
how query multiple fields into one field? 1
Form Field Date Comparison 3

Back
Top