Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
Using Excel 2007.
I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
I have a option in my Table add-in for days
Create a Table of you range and use the Date button on the Table tools Ribbon http://www.rondebruin.nl/table.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Madiya" wrote in message ... Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
I'd insert a new column and use a formula like:
=text(a2,"dddd") and filter by that. FYI only, in xl2003 if I format real dates with a custom number format of dddd, I see the days of the week, not the dates. Madiya wrote: Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
Hi Dave
FYI only, in xl2003 if I format real dates with a custom number format of dddd, I see the days of the week, not the dates. Another difference between 2003-2007 <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I'd insert a new column and use a formula like: =text(a2,"dddd") and filter by that. FYI only, in xl2003 if I format real dates with a custom number format of dddd, I see the days of the week, not the dates. Madiya wrote: Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya -- Dave Peterson __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
xl2007 has a lot of "enhancements" (not just differences!).
<vbg Ron de Bruin wrote: Hi Dave FYI only, in xl2003 if I format real dates with a custom number format of dddd, I see the days of the week, not the dates. Another difference between 2003-2007 <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... I'd insert a new column and use a formula like: =text(a2,"dddd") and filter by that. FYI only, in xl2003 if I format real dates with a custom number format of dddd, I see the days of the week, not the dates. Madiya wrote: Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya -- Dave Peterson __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
Hi Ron
I had not realised that you had updated the add-in to include this. I have just updated my download. It is very nice - thank you. -- Regards Roger Govier "Ron de Bruin" wrote in message ... I have a option in my Table add-in for days Create a Table of you range and use the Date button on the Table tools Ribbon http://www.rondebruin.nl/table.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Madiya" wrote in message ... Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
Hi
I have just tried Ron's add-in and it works perfectly for this (and many other date options as well). If, for any reason, you are not allowed to to use add-ins, then you could insert a new column adjacent to your date column with the formula =WEEKDAY(A2) and copied down. Filter on 5 for Thursday etc. -- Regards Roger Govier "Madiya" wrote in message ... Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
I hope you like it Roger
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Roger Govier" <roger@technology4unospamdotcodotuk wrote in message ... Hi I have just tried Ron's add-in and it works perfectly for this (and many other date options as well). If, for any reason, you are not allowed to to use add-ins, then you could insert a new column adjacent to your date column with the formula =WEEKDAY(A2) and copied down. Filter on 5 for Thursday etc. -- Regards Roger Govier "Madiya" wrote in message ... Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter on Day
On Mar 28, 10:29*pm, "Ron de Bruin" wrote:
I hope you like it Roger -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "Roger Govier" <roger@technology4unospamdotcodotuk wrote in ... Hi I have just tried Ron's add-in and it works perfectly for this (and many other date options as well). If, for any reason, you are not allowed to to use add-ins, then you could insert a new column adjacent to your date column with the formula =WEEKDAY(A2) and copied down. Filter on 5 for Thursday etc. -- Regards Roger Govier "Madiya" wrote in message ... Using Excel 2007. I have 6000+ rows of data with date. When I formate date with DDDD, I can see sunday, monday etc but if I click on autofilter, all dates are listed instead of day. I want to filter on Monday, or tuesday or sunday....but excel does not like it. How to do that. Pl help me. Regards, madiya __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 3972 (20090328) __________ The message was checked by ESET Smart Security. http://www.eset.com- Hide quoted text - - Show quoted text - Hi all, Thanks for all the help. Its nice to get a solution on monday morning and that too by so many people. and both the solutions works for xl2003 and xl2007. Thanks Ron, I have downloaded your addin and exploring the same. Regards, Madiya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |