Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Hi,
I am attempting to sort a list of companies that are formatted in our database system by month/date/year (mm/dd/yyyy). I want them to sort by month and date only, however Excel 2000 recognizes the year as a criteria. How do I get the program to ignore the year information for these 4,000+ entries? Thanks so much. SMW820 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
An indirect way:
Insert two extra columns - one for month using MONTH function and another for day using DAY function. Then sort by month and day. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "SMW820" wrote in message ... Hi, I am attempting to sort a list of companies that are formatted in our database system by month/date/year (mm/dd/yyyy). I want them to sort by month and date only, however Excel 2000 recognizes the year as a criteria. How do I get the program to ignore the year information for these 4,000+ entries? Thanks so much. SMW820 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Hi,
you could use an auxiliar column with =month(a1)&day(a1) copy it down and sort by this column HTH Regards from Brazil Marcelo "SMW820" escreveu: Hi, I am attempting to sort a list of companies that are formatted in our database system by month/date/year (mm/dd/yyyy). I want them to sort by month and date only, however Excel 2000 recognizes the year as a criteria. How do I get the program to ignore the year information for these 4,000+ entries? Thanks so much. SMW820 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Hi Daniel:
Thank you for your solution. At first I did not understand. After reading the second response from Marcelo, I got it! And it worked! Thanks again. SMW820 "Daniel CHEN" wrote: An indirect way: Insert two extra columns - one for month using MONTH function and another for day using DAY function. Then sort by month and day. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "SMW820" wrote in message ... Hi, I am attempting to sort a list of companies that are formatted in our database system by month/date/year (mm/dd/yyyy). I want them to sort by month and date only, however Excel 2000 recognizes the year as a criteria. How do I get the program to ignore the year information for these 4,000+ entries? Thanks so much. SMW820 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Hi Marcelo:
Thank you for your response. I had received another similar solution prior to yours, and did not understand. I gained clarity after reading your answer. And it worked! Thanks so much. SMW820 "Marcelo" wrote: Hi, you could use an auxiliar column with =month(a1)&day(a1) copy it down and sort by this column HTH Regards from Brazil Marcelo "SMW820" escreveu: Hi, I am attempting to sort a list of companies that are formatted in our database system by month/date/year (mm/dd/yyyy). I want them to sort by month and date only, however Excel 2000 recognizes the year as a criteria. How do I get the program to ignore the year information for these 4,000+ entries? Thanks so much. SMW820 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Marcelo Wrote: Hi, you could use an auxiliar column with =month(a1)&day(a1) copy it down and sort by this column HTH Regards from Brazil Marcelo I think you'd have a problem with this approach. 11th January and 1st november would both become 111. For a one column approach try =DATE(0,MONTH(A1),DAY(A1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=554245 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort month/date/year data using month and date only
Hi "daddylonglegs",
Yes, I can see where this might become an issue and luckily I did not have any of these dates in the system. However, I will also keep this version of the recommended solutions on hand for future reference. Thanks very much for your help. SMW820 "daddylonglegs" wrote: Marcelo Wrote: Hi, you could use an auxiliar column with =month(a1)&day(a1) copy it down and sort by this column HTH Regards from Brazil Marcelo I think you'd have a problem with this approach. 11th January and 1st november would both become 111. For a one column approach try =DATE(0,MONTH(A1),DAY(A1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=554245 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do you sort a date range by month? | Excel Discussion (Misc queries) |