Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter Issue
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 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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter Issue
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 wrote in message oups.com... 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 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |