Google Spreadsheet Post #2021
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.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-14-2016
post by: Abby Samotis:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/-SN-HUxkz8U;context-place=forum/docsPulling 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.
Advice?
-----------------------------------------------------------------------------------
