By dynamically do you mean as you add more names and distances or edit
current data the columns will sort without clicking on sort icon?

Can be done but I don't think it is good practice.

If a mistake is made during input, the data sorts and it can be hard to
pinpoint the error cell.

Check out this thread from google search.

http://tinyurl.com/39p64f

Shows a couple of methods for autosorting.

Sandy Mann event code and Ragdyer worksheet funtions.


Gord Dibben MS Excel MVP

On Wed, 3 Sep 2008 18:26:01 -0700, Wereman
wrote:

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?