Need some quick help with Excel

[davester]

Sort works by columns, not rows. You can do an edit/copy/paste special/transpose to get the data into columns, not rows, then do a data/sort on each column individually to rank the scores. You can then do another transpose operation if you want to get everthing back to rows.