I believe the way to do that is first select the column to sort by, then 'select all' and then do the sort On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick _______________________________________________ Utah-Astronomy mailing list http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
Send messages to the list to Utah-Astronomy@mailman.xmission.com <javascript:;>
The Utah-Astronomy mailing list is not affiliated with any astronomy club.
To unsubscribe go to: http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Then enter your email address in the space provided and click on "Unsubscribe or edit options".
-- Sent from my iPad