Sorting Month Only

[joeldsmt]

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.

 

[Selvarathinam]

Put the below formula & copy the same till u need.

=TEXT(A1,"mm/dd")

01/01/02 = "01/01"

the above formula will provide u as "01/01", if u need the result as
JAN/01, then use "mmm/dd", for January/01 then use "mmmm/dd"

Hope the above solution will help u.

 

[joeldsmt]

I will try this.

Thank you.

 

[Roger Govier]

Hi

Assuming your dates are in column A, create a helper column alongside
your data with formula = MONTH(A1)
and copy down for the complete range.
Mark your block of data including the new helper column, and sort by the
new column.

 

[joeldsmt]

WOW...

Worked beautifully!!!

Thanks.