Thursday, January 14, 2016

yogi_Pull Name Of Grade Winner Scoring Maximum Number Of Total Points By Specified Grade

Google Spreadsheet   Post  #2021
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-14-2016
post by: Abby Samotis:!topic/docs/-SN-HUxkz8U;context-place=forum/docs
Pulling max from several data points in a sheet.
I have a sheet that records points per grades 7-12 by student name. I would like to pull the name of the student with the most points in a grade and report it in a separate cells. 

Therefore I want to pull the name cell, based on two cells of data: most points, and grade. My end goal is to report the student of each grade 7-12  by name.