05-02-2007, 05:33 PM
Suppose I have a list of fifty or so people, with 14 numerical scores per person, like so:
Person A 10 8 6 8 2 1 3 4 8 9 3 4 6 9
Person B 1 3 8 8 1 9 8 7 8 0 1 2 5 6
Person C 9 4 5 8 9 1 2 3 5 9 8 7 8 6
Person A's name is in column 1, and each score is in a separate column (e.g., 14 columns total for all the scores)
How do I sort the data so that, by person, their individual scores are listed in high-to-low order? I just tried the "Sort" command, but cannot seem to figure out the right settings to get it to do it the way I want, e.g., not sort the people, but sort the scores within each person...)
I'm sure this is something fairly obvious, but somehow I'm not seeing it...
TiA
Person A 10 8 6 8 2 1 3 4 8 9 3 4 6 9
Person B 1 3 8 8 1 9 8 7 8 0 1 2 5 6
Person C 9 4 5 8 9 1 2 3 5 9 8 7 8 6
Person A's name is in column 1, and each score is in a separate column (e.g., 14 columns total for all the scores)
How do I sort the data so that, by person, their individual scores are listed in high-to-low order? I just tried the "Sort" command, but cannot seem to figure out the right settings to get it to do it the way I want, e.g., not sort the people, but sort the scores within each person...)
I'm sure this is something fairly obvious, but somehow I'm not seeing it...
TiA