Ms Excel
This query is : Resolved
15 February 2010
Can any one tell me how to sort by date in ms excell
when i am trying to sort in date format ex:dd/mm/yy then date wise only changed but month not changed in order
will you tell me procedure
when i am trying to sort in date format ex:dd/mm/yy then date wise only changed but month not changed in order
will you tell me procedure
15 February 2010
Try this step >
1. Select the data in column for sorting.
2. Go to Data>Sort and select the column for starting.
It will sort the date format also.
I don't understand about month wise..even the month also includes some date only.
Like if u right March 09, it will take 31.3.09
or if u right Feb,09 then it wil take it as 28.2.09.
and if u sort it in ascending order, then the date of 28.2.09 will preeeced 31.3.09.
I hope it solves ur problem.
1. Select the data in column for sorting.
2. Go to Data>Sort and select the column for starting.
It will sort the date format also.
I don't understand about month wise..even the month also includes some date only.
Like if u right March 09, it will take 31.3.09
or if u right Feb,09 then it wil take it as 28.2.09.
and if u sort it in ascending order, then the date of 28.2.09 will preeeced 31.3.09.
I hope it solves ur problem.
15 February 2010
Thanku but not workout
if dates are 04/01/2009
01/05/2009
03/02/2009
in above case when iam sort : the result is as below
01/05/2009
03/02/2009
04/01/2009
if dates are 04/01/2009
01/05/2009
03/02/2009
in above case when iam sort : the result is as below
01/05/2009
03/02/2009
04/01/2009
15 February 2010
Its working..
be sure that the format of all the dates are same..
dd/mm/yy or mm/dd/yy.
i.e 4/1/2009 shud be 4th Jan
1/5/2009 shud be 1st May
3/2/2009 shuid be 3rd feb.
or if other format is using, then
4/1/2009 shud be 1st April
1/5/2009 shud be 5th Jan
3/2/2009 shud be 2nd March..
BE ENSURE ALL ARE RESPRESENTING SAME FORMAT. IF DIFFERENT FORMAT FOR DIFF DATES..IT WILL NOT WORK.
be sure that the format of all the dates are same..
dd/mm/yy or mm/dd/yy.
i.e 4/1/2009 shud be 4th Jan
1/5/2009 shud be 1st May
3/2/2009 shuid be 3rd feb.
or if other format is using, then
4/1/2009 shud be 1st April
1/5/2009 shud be 5th Jan
3/2/2009 shud be 2nd March..
BE ENSURE ALL ARE RESPRESENTING SAME FORMAT. IF DIFFERENT FORMAT FOR DIFF DATES..IT WILL NOT WORK.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Sale of property furniture sale
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- RCM INVOICING FROM NOV-2024
- Confusion around Form 26QB fields
- TDS under section and rate of TDS
- GST input on scooter purchased
- TDS under section 194Q and TCS under section 206C
- GST input on car insurance and repairs
- GST input on Diwali gift to employee
- GST input on Mobile Handset
- Material and freight in same invoice
- TDS under section 194J inclusive of reimbursement of expenses
- TDS on Material and Labour in same invoice
- Should I be worried about and rectify reporting Jan,Feb ,March 2024 foreign salary in schedule FA?
Trending Online Classes
CAclubindia
