Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
rcc rcc is offline
external usenet poster
 
Posts: 21
Default date sorting

When I try sorting a column of dates, excel puts (for example) 06/2000 first
and then 01/2001 next. It obviously makes sense that it would do that, but
what I want is to group all the Januarys together first and then all the
Junes together next, regardless of year. Is it possible for me to sort by
month, with no regard to the year?

Thanks.
Renee
 
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
Sorting by Date, And SUM Zee Excel Discussion (Misc queries) 1 July 31st 06 12:30 PM
Sorting By Date Scott Robson Excel Discussion (Misc queries) 1 February 13th 06 10:16 AM
sorting by date debradebra Excel Worksheet Functions 3 January 11th 06 09:49 PM
sorting date " MMM-YY" (Jan-05) GEORGIA Excel Discussion (Misc queries) 8 June 23rd 05 01:30 PM
Sorting by date when the date isn't exact Kim Excel Discussion (Misc queries) 1 May 5th 05 10:44 PM


All times are GMT +1. The time now is 03:57 AM.

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"