I'm designing an Excel spreadsheet to handle our school's athletics day. In
column I have a list of kids' names and in Column B I have the distances they
threw a ball. I would like to sort the distances from furthest to nearest and
naturally have the names go with the numbers so that I can determine who came
first, second and so on in that event. I need to do this dynamically as
opposed to manually.

Any ideas?