| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do you sort the data by the month of the date?
Hi, The file has date formate as MM/DD/YYYY and I want to keep it
that way. Is there anyway the file can be sorted by only MM? I am trying to sort by Jan, Feb, March...... November, December together. Thanks, Saz |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do you sort the data by the month of the date?
Using a helper column is one way. With your data in A1 down put this in B1
and drag down =MONTH(A1) Select columns A&B and sort by column B. Mike "Saz" wrote: Hi, The file has date formate as MM/DD/YYYY and I want to keep it that way. Is there anyway the file can be sorted by only MM? I am trying to sort by Jan, Feb, March...... November, December together. Thanks, Saz |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do you sort the data by the month of the date?
Thank you Mike.... =)
On Aug 15, 8:04 am, Mike H wrote: Using a helper column is one way. With your data in A1 down put this in B1 and drag down =MONTH(A1) Select columns A&B and sort by column B. Mike "Saz" wrote: Hi, The file has date formate as MM/DD/YYYY and I want to keep it that way. Is there anyway the file can be sorted by only MM? I am trying to sort by Jan, Feb, March...... November, December together. Thanks, Saz- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do you sort the data by the month of the date?
Another option is to use this add-in
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Saz" wrote in message ups.com... Hi, The file has date formate as MM/DD/YYYY and I want to keep it that way. Is there anyway the file can be sorted by only MM? I am trying to sort by Jan, Feb, March...... November, December together. Thanks, Saz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort by month and date only | Excel Discussion (Misc queries) | |||
| I want to sort by month, date, year. Birthdates. How do I do it | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
| How do you sort a date range by month? | Excel Discussion (Misc queries) | |||
Linear Mode
