Thursday, September 11, 2014

yogi_Compute Maximum Score By Grade Row By Row For Specified Student Number For Each Grade

                      Google Spreadsheet   Post  #1758
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep-11-2014
post by Ben Weston:
Returning max value from columns with a certain header
I'm having trouble wrapping my head around the issue of how to return the max value from a number of different columns, but only if that column has a specific header.  

Here is an example:
Student Code

So, I want to find out the highest score that a student has received in standard one (highest of any column that has a 1 as a header), then I would have a separate cell that calculates the highest score a student has received in standard 2, and so on. I would then have this repeated for each student which I believe calls for the $ sign in the standard portion.

Desired outputs for:
Standard 1: 3
Standard 2: 3
Standard 3: 2
Standard 4: 4
Standard 5: 2
Standard 6: 3 

I know there has to be a better solution than a crazy complex set of nested if/and statements.