yogi_Tabulate StudentName And Student's Best Score From A List Of Student Names And Scores In Another Sheet

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #786  Sep 29, 2012    www.energyefficientbuild.com.

user brianteacher said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/_YYNqLU2Cy4) 
Sort, filter and add using unique values in Google spreadheet
 ....
https://docs.google.com/spreadsheet/ccc?key=0AhfL5EbuOgCAdDlUMV9iandvRzdDQmFuQmVZZG0tanc

I would like the second tab (BestScores) to reflect each student's best effort from tab one (AllScores)

-------------------------------------------------------------------------------------------
following is a solution to the problem
 

yogi_Compute Frequency Of Grades By Possible Grade List

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #785  Sep 29, 2012    www.energyefficientbuild.com.

user brianteacher said: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/u9N4V0H8uFo)
Grade distribution

I found an old thread with a great spreadsheet example by ahab that shows a formula for counting the distribution of letter grades.

https://groups.google.com/d/topic/How-to-Documents/vvhEWGD2UCM/discussion

I was wondering if there would be a way to adapt such a formula to return "0" if there are no (for example) "D" grades.

------------------------------------------------------------------------------------------------

following is a solution to the problem