In the attached file I have some data. I'd like to transform its order in a way that the first date would be the last date and all the columns on its side will follow..
How could i do it? i tried sor oldest to newest but it seems that its mixing my data
Thanks in advance,
Hidai
In what way is it mixing up the data?
If you select the entire range and Sort column A oldest to newest (keep my data has a header unchecked), then it seems to sort fine.
Notice that for each date, it is keeping the group together, in that the oldest time is the first record for each date, and so the oldest time shows up at top of each record after sorting, that is why you are not seeing the last row at the top after sorting.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yeah thats exactly what i mean by mixing up the data.. after sorting, the dates are ordered from the oldest to the newest which is good but as you say my problem that within each data the oldest time appears on the top whereas I want i to appear on the bottom.. could it be done?
I have Excel 2007 but when I go to a custom sort, it allows me to pick "oldest to newest" for Col A and "Smallest to biggest" for column B. Does 2003 not allow that?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Add a sort level and sort column B smallest to biggest.
Cool. thx guys. Problem solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks