Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LisaMU
 
Posts: n/a
Default How can I sort multiple months/years WITHOUT Alpha order taking o.

Trying to sort 3 years of data, which is in month and year fashion. How can
I segregate and sort the columns so that the years grop together? Excell
seems to group the alpha order of jan, feb, mar, and does not recognize the
true values as Jan-02, Jan-03, jan-04...is there a way to get this to sort by
year grouping jan 02, feb-02, mar-02, followed by jan-04,feb-04, mar-04.
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

Insert in the column next to the months (that are entered as text) the
following:
=datevalue(A1)
where cell a1 is the cell holding the months data
Now copy it down to the end of the list
Now sort it using the newly created column as the criterion.


"LisaMU" wrote in message
...
Trying to sort 3 years of data, which is in month and year fashion. How
can
I segregate and sort the columns so that the years grop together? Excell
seems to group the alpha order of jan, feb, mar, and does not recognize
the
true values as Jan-02, Jan-03, jan-04...is there a way to get this to sort
by
year grouping jan 02, feb-02, mar-02, followed by jan-04,feb-04, mar-04.



Reply
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
using sumif & countif to sort multiple cells floridasurfn Excel Worksheet Functions 3 February 27th 05 10:23 PM
way to automaitic sort sheet one numerical, sheet two alpha? wichita6 Excel Worksheet Functions 3 February 11th 05 04:43 PM
I want to sort worksheets in a workbook into Alpha order? thecattah Excel Worksheet Functions 1 January 5th 05 08:06 AM
"-" ignored in sort Mike H Excel Discussion (Misc queries) 8 January 2nd 05 08:48 AM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 11:05 PM


All times are GMT +1. The time now is 08:23 PM.

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

About Us

"It's about Microsoft Excel"