Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting issues
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting issues
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting issues
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting issues | Excel Worksheet Functions | |||
issues in exxcel | Excel Discussion (Misc queries) | |||
Sumproduct issues. | Excel Worksheet Functions | |||
sorting issues for movie titles | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) |