ExcelBanter - Sorting issues

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting issues (https://www.excelbanter.com/excel-discussion-misc-queries/201228-sorting-issues.html)

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?

What does dynamically mean to you?

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

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

Regards,
Fred.

"Wereman" wrote in message
...
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?

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?