Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter when using Date Range Cells
Please help explain how to use Advanced Filter if looking to point formula
(criteria) at two cells for date range. If I enter under duplicate (column headings) =9/18/8 (Dwg Date) and <=1/23/9 (Dwg Date) the filter works. I can't get it to work by using ='Add Modify Project'!$AJ$24, etc. which are cells located on other tab. I have spent hours attempting to get this to work. Any help is greatly appreciated. Jim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter when using Date Range Cells
http://cjoint.com/?bBsaliyufv JB http://boisgontierjacques.free.fr On 25 jan, 17:39, Jim wrote: Please help explain how to use Advanced Filter if looking to point formula (criteria) at two cells for date range. *If I enter under duplicate (column headings) =9/18/8 (Dwg Date) and <=1/23/9 (Dwg Date) the filter works. *I can't get it to work by using ='Add Modify Project'!$AJ$24, etc. which are cells located on other tab. *I have spent hours attempting to get this to work. *Any help is greatly appreciated. *Jim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter when using Date Range Cells
Hey JB - Great Job with Providing examples - I got it to work. Thanks Much!
"JB" wrote: http://cjoint.com/?bBsaliyufv JB http://boisgontierjacques.free.fr On 25 jan, 17:39, Jim wrote: Please help explain how to use Advanced Filter if looking to point formula (criteria) at two cells for date range. If I enter under duplicate (column headings) =9/18/8 (Dwg Date) and <=1/23/9 (Dwg Date) the filter works. I can't get it to work by using ='Add Modify Project'!$AJ$24, etc. which are cells located on other tab. I have spent hours attempting to get this to work. Any help is greatly appreciated. Jim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced Filter when using Date Range Cells
Hi,
For calculated criteria do not use the same title as in the database, make up anything else. this may be what the web sites told you but I don't have time to read them. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Jim" wrote: Please help explain how to use Advanced Filter if looking to point formula (criteria) at two cells for date range. If I enter under duplicate (column headings) =9/18/8 (Dwg Date) and <=1/23/9 (Dwg Date) the filter works. I can't get it to work by using ='Add Modify Project'!$AJ$24, etc. which are cells located on other tab. I have spent hours attempting to get this to work. Any help is greatly appreciated. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter using a range name as the criteria | Excel Worksheet Functions | |||
Advanced filter a dynamic date range | Excel Worksheet Functions | |||
advanced filter a range | Excel Worksheet Functions | |||
Advanced filter and Criteria Range | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |