I'm currently working in a school and students answered a 50 question form on ICT Ability. The results of this form have been put into a spreadsheet and I have to order the names in terms of ability. I know how to do each row to check if the answer was correct but I'm wondering if I put in a row with the correct answers, is there a way to rank each student in a percentage with how many answered the same as the row?Sample data:Name    Q1      Q2      Q3      Q4 Answer  No      True    False   Portait  John    No      True    False   Portait  Jenny   Yes     True    True    Landscape April   Yes     False   True    LandscapeSample result:Name    %John    100April   25Jenny   0
Grading a Google Spreadsheet by answers given in a Google Form
google spreadsheets;google apps script