LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
joeldsmt
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
Sorting by month, disregarding the year Soffi Excel Discussion (Misc queries) 3 September 26th 05 07:52 PM
Sorting a lsit by month mike_vr Excel Discussion (Misc queries) 1 April 11th 05 01:10 PM
Sorting birthdays by month and day Craig Excel Discussion (Misc queries) 4 March 3rd 05 02:23 AM
Month Year Date Format Jamie Excel Worksheet Functions 2 February 7th 05 06:43 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"