grades

B

boogie

A B C
D E
1 MM012 Martin Mann Computer 90
2 Math
75
3 History
65
4 Science
100
6 EG013 Earnest Go Computer 100
7 Math
93
8 History
70
9 Science
35

Question: On column E1, I want to get who is the highest in Computer and on
E2, the highest on Math and so on. I have 50 subjects to all grade level in
4000 rows and more than 300 students. Thanks.
 
G

Guest

A B C D E
1 M012 Martin Computer 90
2 Math 75
3 History 65
4 Science 100
6 E013 Earn Go Computer 100
7 Math 93
8 History 70
9 Science 85

Question: On column E1, I want to get who is the highest
in Computer (with name,subject and grade) and on E2, the
highest on Math and so on. I have 50 subjects to all grade
level in4000 rows and more than 300 students. Thanks.
 
Top