grades

[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.

 

[Peter Atherton]

I'm afraid that I can't read your table But a SUMPRODUCT
function an an array formula should do it.

(e-mail address removed)

Regards
Peter

 

[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.