Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter on Day
On Sep 8, 2:26*pm, Javed wrote:
Dear Madiya, I f you can change the number format of the column then easily you can do what you want. Step 1:From Excel Options--Advanced--Uncheck the Group Dates Auto Filter menu Step 2:Change the Number format .Select Format cells from right click-- In the number tab go to Custom and type dddd in edit box. This will show all the date in Weekday (ie Sunday,Monday).then you can filter. Both solutions worked. Thanks a ton to both of you. Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |