LinkBack URL
About LinkBacks
I have an excel sheet where I want to sort data in Ascending Order of Date.
How to do it?
PFA
How to sort data in Ascending Order of Date
I have an excel sheet where I want to sort data in Ascending Order of Date.
How to do it?
PFA
You can't as it stands because your date and time column is not properly formatted as date and time, so Excel will see it only as text and can therefore only attempt to sort it alphabetically for you, not numerically. You need to get the contents of that column formatted properly, and then you can use Excel's filters to sort the data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
One way you can do sorting.
In "G" column add "Helper" & enter formula in "G2"copy paste down.Formula:
=LEFT(C2,11)
Then sort by "Helper" > by "Order" : A to Z
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hello AVK,
using ur first formula able to covert in date format. But then didn't understand how to go next with the formula u have given. ("Helper" > by "Order" : A to Z)
Refer attach file.
You need to do only in "G" column formula as per post #3 (Format as Date)
Then sort by "Helper" > by "Order" : A to Z
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks