Sub:guide urgent [Closed]

Report
Posts
1
Registration date
Wednesday August 29, 2012
Status
Member
Last seen
August 29, 2012
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
The following is sample data, i want to sort through month, not year , please guide which format may i use, to sort data.

31/08/2006
31/08/2006
31/08/2003
31/08/2002
31/08/2001
31/07/2011
31/07/2011
31/07/2011
31/07/2011
31/07/2010
31/07/2010
31/07/2009
I am waiting your reply,
Thanx
kishori



1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
sorting does not depend upon format,.
suppose your data is from A2 down(A1 having column heading)
in B2 copy this formula
=month(A2)
and copy this down the B column(type some thing e.g. month in B1)
now highlight both columns and sort according to B
after sorting if you want you cant delete column B

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!