| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Month Only
Hello, I have a sheet that has 4 years worth of information. For a recent report i need to sort the data without caring about the year. For instance i want to have all Januarys 2002-2005 in order by date, then Feb 2002-2005 etc... No matter what i do it sorts in order from 01/01/02-12/31/05. Any ideas? Im stumped. Thank you all in advance. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=503108 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Month Only
Put the below formula & copy the same till u need.
=TEXT(A1,"mm/dd") 01/01/02 = "01/01" the above formula will provide u as "01/01", if u need the result as JAN/01, then use "mmm/dd", for January/01 then use "mmmm/dd" Hope the above solution will help u. ---- Selvarathinam. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Month Only
I will try this. Thank you. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=503108 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Month Only
Hi
Assuming your dates are in column A, create a helper column alongside your data with formula = MONTH(A1) and copy down for the complete range. Mark your block of data including the new helper column, and sort by the new column. -- Regards Roger Govier "joeldsmt" wrote in message ... Hello, I have a sheet that has 4 years worth of information. For a recent report i need to sort the data without caring about the year. For instance i want to have all Januarys 2002-2005 in order by date, then Feb 2002-2005 etc... No matter what i do it sorts in order from 01/01/02-12/31/05. Any ideas? Im stumped. Thank you all in advance. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=503108 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting Month Only
WOW... Worked beautifully!!! Thanks. -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=503108 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Sorting by month, disregarding the year | Excel Discussion (Misc queries) | |||
| Sorting a lsit by month | Excel Discussion (Misc queries) | |||
| Sorting birthdays by month and day | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
