Excel should sort by month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wahine15 - 29 Aug 2006 17:39 GMT

It would be great if Excel could sort by month name, such as Jan, Feb, Mar,
etc.

Reply to this Message

Bob Phillips - 29 Aug 2006 17:42 GMT

Create a helper column with this formula

=TEXT(A1,"mmm")

and sort by that column.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> It would be great if Excel could sort by month name, such as Jan, Feb, Mar,
> etc.
[quoted text clipped - 5 lines]
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=88d74424-8cef-4
757-ae9d-693ff7b876f3&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Bernard Liengme - 29 Aug 2006 18:20 GMT

If your months (Jan, Feb...) are in A, use helper column with
=MATCH(A1,{"Jan","Feb","Mar","Apr","May","June", ..........}, 0)
Sort by this column

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Create a helper column with this formula
>
[quoted text clipped - 17 lines]
>>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=88d74424-8cef-4
757-ae9d-693ff7b876f3&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Gord Dibben - 29 Aug 2006 18:36 GMT

While you're waiting for the developers to get around to it, try this.

Assume dates in column A

In B1 enter =MONTH(A1)

Double-click on the fill handle of B1 to copy down.

Sort on Column B

Gord Dibben MS Excel MVP

>It would be great if Excel could sort by month name, such as Jan, Feb, Mar,
>etc.
[quoted text clipped - 7 lines]
>
>http://www.microsoft.com/office/community/en-us/default.mspx?mid=88d74424-8cef-4
757-ae9d-693ff7b876f3&dg=microsoft.public.excel.worksheet.functions

Reply to this Message