Sorting Month Only
 

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.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=503108

Sorting Month Only
 

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.

----
Selvarathinam.

Sorting Month Only
 

I will try this.

Thank you.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=503108

Sorting Month Only
 

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.

--
Regards

Roger Govier


"joeldsmt" wrote
in message ...

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.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile:
http://www.excelforum.com/member.php...o&userid=11889
View this thread:
http://www.excelforum.com/showthread...hreadid=503108

Sorting Month Only
 

WOW...

Worked beautifully!!!

Thanks.


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=503108