Previous Topic Next Topic

Sub:guide urgent

Closed
kishori Posts 1 Registration date Wednesday August 29, 2012 Status Member Last seen August 29, 2012 - Aug 29, 2012 at 03:33 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 30, 2012 at 01:33 AM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 30, 2012 at 01:33 AM
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
0