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.
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.
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" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
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" <[email protected]> wrote in message
news:#[email protected]...
> 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.
>
>
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" <[email protected]> wrote in message news:%[email protected]...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks