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     www.energyefficientbuild.com.   Sep-11-2014
post by Ben Weston:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/P5RfRbdhpjc)
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:

Standard	1	2	1	3	4	1	4	5	6	1	6
Student Code
7788	2	3	2	2	4	1	1	2	1	3	3

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.

Thanks!!!

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