Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
Can someone pleased help. I wish to used the advanced filter to filter
results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and 31/03/2008. What is the format for the filter criteria and should the criteria be on one row or 2? Any assistance is greatly appreciated. -- Thankyou RM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
Hi
One row For Example in A1 and B1 the Column Name and in A2 and B2 the criteria and the dates. Use the US date format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rm" wrote in message ... Can someone pleased help. I wish to used the advanced filter to filter results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and 31/03/2008. What is the format for the filter criteria and should the criteria be on one row or 2? Any assistance is greatly appreciated. -- Thankyou RM |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
Dates Data Base in B2:Bxxx
FisrtDate In F2 LastDate In G2 Criteria: D1:D2 Formula in D2: =And(B2=$F$2,B2<=$G$2) http://cjoint.com/?bvrISc1MjG JB http://boisgontierjacques.free.fr On 19 jan, 17:16, rm wrote: Can someone pleased help. I wish to used the advanced filter to filter results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and *31/03/2008.. What is the format for the filter criteria and should the criteria be on one row or 2? *Any assistance is greatly appreciated. -- Thankyou RM |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
Thanks Ron,
It doesn't seem to work so I am a little confused. All the dates in the spreadsheet are in column A so presumable date criteria needs also to be in column A in the criteria range. Can you give an example of a suitable formula or format for the criteria? -- Thankyou RM "Ron de Bruin" wrote: Hi One row For Example in A1 and B1 the Column Name and in A2 and B2 the criteria and the dates. Use the US date format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rm" wrote in message ... Can someone pleased help. I wish to used the advanced filter to filter results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and 31/03/2008. What is the format for the filter criteria and should the criteria be on one row or 2? Any assistance is greatly appreciated. -- Thankyou RM |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
try using Custom Filter,
1. Choose Filter under Data on the menu bar 2. Click on the filter arrow 3. Choose Custom 4. click on the first drop down and select is greater than or equal to 5. click on the drop down beside the first and choose your date 6. tick And 7. click on the 3rd drop down below the first and select is less than or equal to 8. click on the drop down beside the 3rd and choose the date 9. click OK this will give the range of data between the dates you have specified. HTH -- Your feedback is very much appreciate, pls click on the Yes button below if this posting is helpful. Thank You cheers, francis "rm" wrote: Thanks Ron, It doesn't seem to work so I am a little confused. All the dates in the spreadsheet are in column A so presumable date criteria needs also to be in column A in the criteria range. Can you give an example of a suitable formula or format for the criteria? -- Thankyou RM "Ron de Bruin" wrote: Hi One row For Example in A1 and B1 the Column Name and in A2 and B2 the criteria and the dates. Use the US date format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rm" wrote in message ... Can someone pleased help. I wish to used the advanced filter to filter results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and 31/03/2008. What is the format for the filter criteria and should the criteria be on one row or 2? Any assistance is greatly appreciated. -- Thankyou RM |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Advanced filter - Filtering using dates
Hi
You critera range is four cells now and can be in any column you want above your data range Install EasyFilter if you want it easy http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rm" wrote in message ... Thanks Ron, It doesn't seem to work so I am a little confused. All the dates in the spreadsheet are in column A so presumable date criteria needs also to be in column A in the criteria range. Can you give an example of a suitable formula or format for the criteria? -- Thankyou RM "Ron de Bruin" wrote: Hi One row For Example in A1 and B1 the Column Name and in A2 and B2 the criteria and the dates. Use the US date format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rm" wrote in message ... Can someone pleased help. I wish to used the advanced filter to filter results between 2 seperate dates in a worksheet. For example I wish to display all rows where the date lies between 01/01/2008 and 31/03/2008. What is the format for the filter criteria and should the criteria be on one row or 2? Any assistance is greatly appreciated. -- Thankyou RM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter using dates | Excel Discussion (Misc queries) | |||
Advanced Filter not filtering | Excel Discussion (Misc queries) | |||
Getting no results from Advanced Filtering in Excel 2007 | Excel Discussion (Misc queries) | |||
Advanced filter dates and nulls | Excel Worksheet Functions | |||
ADVANCED FILTERING IN EXCEL 2003 | Excel Discussion (Misc queries) |