Saturday, September 29, 2012

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