Have you tried the sort option? It's found under the Data menu. You need to highlight the complete spreadsheet using CTRL + A, then under the sort option, select the column containing the scores, and choose asending or desending. that should hopefully put it in the correct order.
If you want to bring the name up automatically, then you need to use the IF statement. Let me know if you want to use that feature, as my wife uses Excel all the time.