Previous Topic Next Topic

Sub:guide urgent

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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
30 Aug 2012 à 01:33
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