How do I sort by CALENDAR order?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that has a column for Calendar Month Name. I want my data sorted by Calendar Order not alphabetically. The first row should be October, second November, December, January. I've attempted doing this with first key sort order under Sort > Options but it doesn't seem to work. Any ideas?
 
You have to create your own list to do that or use real dates as opposed to
text months, you can still format it to look like the name of the month,
i.e.

for October use 10/01/04 (or whatever year you are working with)
then format as mmmm and sort

--

Regards,

Peo Sjoblom


Mark said:
I have a spreadsheet that has a column for Calendar Month Name. I want my
Click to expand...
data sorted by Calendar Order not alphabetically. The first row should be
October, second November, December, January. I've attempted doing this with
first key sort order under Sort > Options but it doesn't seem to work. Any
ideas?
 
Thanks! That did the trick!
-----Original Message-----
You have to create your own list to do that or use real dates as opposed to
text months, you can still format it to look like the name of the month,
i.e.

for October use 10/01/04 (or whatever year you are working with)
then format as mmmm and sort

--

Regards,

Peo Sjoblom



(e-mail address removed)... Month Name. I want my
data sorted by Calendar Order not alphabetically. The first row should be
October, second November, December, January. I've attempted doing this with
first key sort order under Sort > Options but it doesn't seem to work. Any
ideas?


.
Click to expand...
 
Back
Top