Here's the way the file is produced: http://users.wirelessbeehive.com/~paw/temp/excelchallenge.zip Looks like it's going to be a long night of data-taking tonight (yea!) so I'll have lots of time to try out the various suggestions that have been made here today. Thanks all! patrick On 08 May 2012, at 15:43, Patrick wrote:
Hi,
The original is a text file.
I'm converting it to Excel so I can use Excel's sort function since I don't think text files can be sorted.
I'll post a complete original file when I get home this evening for folks to play with.
Thanks to all for their help.
patrick
On 08 May 2012, at 14:12 , Chrismo wrote:
i guess i'm not understanding how the original data is formatted. is this stuff: SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
not in a spreadsheet to start off with?