Sorting issues

[Wereman]

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?

 

[Fred Smith]

What does dynamically mean to you?

The standard way is to select the range (ie b1:i30), then use Data>Sort.

If doesn't do what you want, post back with more information.

Regards,
Fred.

 

[Gord Dibben]

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