Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to filter more than one date
Excel 2003/XP
I have an Excel sheet that has numerous rows and columns that I want to filter by 3 dates. I can use AutoFilter and filter one date but the others won't show up. I don't want to show the entire worksheet. Please advise. Thank you. |
#2
|
|||
|
|||
Hi
this can be achived using advanced filtering - check out http://www.contextures.com/xladvfilter01.html for details -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "HT" wrote in message ... Excel 2003/XP I have an Excel sheet that has numerous rows and columns that I want to filter by 3 dates. I can use AutoFilter and filter one date but the others won't show up. I don't want to show the entire worksheet. Please advise. Thank you. |
#3
|
|||
|
|||
Use a helper column and insert this formula at the top of your column A1 if
no header, and copy down......... Put the three dates you wish to filter for in D1, E1, and F1....... =IF(OR(A1=$D$1,A1=$E$1,A1=$F$1),A1,"") Then do AutoFilter on this column for Custom "greater than zero" If you want to change which 3 dates you filter, just change them in D1:F1 Vaya con Dios, Chuck, CABGx3 "HT" wrote in message ... Excel 2003/XP I have an Excel sheet that has numerous rows and columns that I want to filter by 3 dates. I can use AutoFilter and filter one date but the others won't show up. I don't want to show the entire worksheet. Please advise. Thank you. |
#4
|
|||
|
|||
Hi
AutoFilter can filter on two dates EasyFilter can do 5 http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "HT" wrote in message ... Excel 2003/XP I have an Excel sheet that has numerous rows and columns that I want to filter by 3 dates. I can use AutoFilter and filter one date but the others won't show up. I don't want to show the entire worksheet. Please advise. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |