I need some help setting up a spreadsheet for a sports tournament.
In cells A1 thru A10, I have a list of schools, sorted alphabetically. In cells B1 thru B10 I have a abbreviation for the school. In C1 thru C10 I have each team's score.
Beneath this list, I want to create a similar list sorted by score (from highest to lowest), rather than sorted alphabetically. I can figure out how to sort the score column, but cannot figure out how to have the corresponding school and abbreviation be matched up with each score.
I would truly appreciate any help. Thanks in advance!
Bookmarks