Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns
I am a member of a 12 team football league. I created a spreadsheet to
keep up with the scores standings ect. I am having trouble getting excel to sort the winning percentages from high to low. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns
Please indicate what is happening instead of working.
I notice that you have a word in your subject that is not in your question. The body of the question must have the complete question or you are certainly not going to get quick and direct answers. If you want to sort columns independent of the other data on the rows then just select a that column then Data, Sort, the rest is self explanatory, but you will have to pay attention to whether to check the my data has headers or not. If you want to sort several columns independently of the other data on the rows, you will need a macro. See SortEachColumn2 macro at http://www.mvps.org/dmcritchie/excel...ng.htm#special I have a few web pages on sorting, you might want to check them out to see if you find your answer or at least as a starting point to ask a question that indicates what you really want. http://www.mvps.org/dmcritchie/excel/sorting.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Bumfuzzled" wrote ... I am a member of a 12 team football league. I created a spreadsheet to keep up with the scores standings ect. I am having trouble getting excel to sort the winning percentages from high to low. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting columns
You shouldn't be getting a problem, just select the columns, go to DataSort
and select the percentage column as the key. But you don't mention what problem you get so it may be something else. -- HTH RP (remove nothere from the email address if mailing direct) "Bumfuzzled" wrote in message oups.com... I am a member of a 12 team football league. I created a spreadsheet to keep up with the scores standings ect. I am having trouble getting excel to sort the winning percentages from high to low. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freezing columns labels while sorting columns | New Users to Excel | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
Sorting columns | Excel Worksheet Functions | |||
Sorting columns | Excel Discussion (Misc queries) | |||
Sorting two columns (again) | Excel Worksheet Functions |