I have a list of 200 names. Each name is shown ten times. This makes my spreadsheet have 2,001 rows of data.
In the columns I have Name, Score, and Max Score. Max Score is empty.
If Joe has scores of 7,4,6,3,8,5,3,2,7, and 4 then the Max Score for him should be 8 (as that is his highest score)...