• I have a sheet (called "Registrants") where racers sign up with their name, phone number, and expected finish time. This list is not sorted.
  • I have a sheet (called "Racers") where I want the data from the Registrants sheet to be ordered by expected finish time.
How can I do this sort without having to manually use the "sort" feature or running a macro? I cannot use INDEX because the array of Registrants is not ordered.

A sample spreadsheet of the situation is available here, though it is in Google Docs format. I'll try and translate it back to Excel 2007 after this issue is solved.

Much thanks.