 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007How 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 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 > Hi, The file has date formate as MM/DD/YYYY and I want to keep it > that [quoted text clipped - 4 lines] > Thanks, > Saz Thank you Mike.... =) > Using a helper column is one way. With your data in A1 down put this in B1 > and drag down [quoted text clipped - 15 lines] > > - Show quoted text - Another option is to use this add-in http://www.rondebruin.nl/easyfilter.htm  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > Hi, The file has date formate as MM/DD/YYYY and I want to keep it > that [quoted text clipped - 4 lines] > Thanks, > Saz
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.