Finding the high score for each student in a column in Google Sheets with multiple attempts turned on

I give students a quiz in Google Forms and allow multiple attempts. I create a Google Sheets file from the results. Now I want to find the high score for each student and match the score to a master list of email addresses returning a value of zero for any students that did not take the quiz.