Sign in to follow this  
Guest

Sorting in Excel...

Recommended Posts

I'm working on the US Airways Schedule to agree with John S. other schedules (Feb 1-7, 2002)I have all of the Hubs in Excel. no problem :) Here is the data format: Date Flight No. Tail Dest Time Arrival 02/01/2002 1480 N107UW STT 11:15 CLT 02/01/2002 124 N108UW BOS 16:50 CLTI'm sorting Date, Tail# and Time. As soon as I add time, it goes wacky- no logic to the times. Cells are formatted as time, and when I sort by time first, it works. When I do not even include time as a sort, I get the same results as sorting with time in slot 3.Any ideas?Tim

Share this post


Link to post
Share on other sites
Help AVSIM continue to serve you!
Please donate today!

should be sorting by tail number... then date... then time-j

Share this post


Link to post
Share on other sites

That is exactly how I do it- when the third sort is Time, it ignores it. If I sort by time first, it works, but everything else is out of order.Tim

Share this post


Link to post
Share on other sites

so, you're excel sort dialog box looks like this?-j

Share this post


Link to post
Share on other sites

Hey Tim?Did you ever figure this out? I think I may have....-j

Share this post


Link to post
Share on other sites

My sort looks exactly like yours, but it ignores time... If I include it third, the seqence is the same as no third sort position.WHat's your solution?Tim

Share this post


Link to post
Share on other sites

did you remove the space in front of the time?if the space is still there, it will treat is a text... you would have to do a global replace (which you should do on the entire sheet anyway) to remove all spaces...ctrl h ... top line... hit the space bar once bottom line ... leave it blank... then click the replace all button....

Share this post


Link to post
Share on other sites

When you are importing the file, why not just flag that column as time?Regards,Bob

Share this post


Link to post
Share on other sites

because you don't need to if you just remove the space (and every column needs the spaces removed anyway).I don't know about you, but I keep the file in text format so that I can put it in ms word when needed to do global find/replace. It would be a waste of time to continually have to 'tag that column as time' when importing it. Excel is smart enough to automatically format the column as time if it appears to be a time value.-j

Share this post


Link to post
Share on other sites

You were right- it's the space.Oh boy, not to put all of these flights into order with the correct syntax!Tim

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this