LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default sorting imported data

Is it possible to sort imported data or another way to sort it?
For example; The time data is imported from another book.
This data is in a time format that changes daily.
Once the time changes the data has to be sorted by earliest times first.
Therefor if I sort the list below A604 should move to be under A605, and
A607 should be first.
Along with A604, 53927/A5 and 9:09 should move with it.

list A List B Time
A604 53927/A5 9:09
A606 53486/A7 7:41
A605 53482/A6 8:41
A603 53923/A4 9:45
A602 53976/A3 9:57
A607 53920/A8 8:00
A601 73209/A2 10:39
A600 53921/A1 10:40

Thanks

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Imported data buzz Excel Worksheet Functions 2 October 17th 07 11:51 PM
DB4 imported data Sasha[_2_] Excel Discussion (Misc queries) 3 August 17th 07 10:32 AM
sorting on imported Data Excel 2007 Dan Shallbetter Excel Discussion (Misc queries) 3 February 19th 07 03:10 PM
Sorting imported .txt data in Excel clickmule Excel Worksheet Functions 3 November 4th 05 02:39 PM
Sorting imported "numbers" Confused on the tundra Excel Discussion (Misc queries) 5 December 17th 04 07:33 PM


All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"