Find avg & Max for grades
Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0))
Max: =CHAR(MIN(CODE(A2:A35)))
Grades should be UPPERCASE
HTH
--
AP
"Param" a écrit dans le message de
...
I have range (A2:A35) for subject grades (A,B,C,D,E)
What I want to know, it is possible to find avg grade and max grade score
by
student?
pls guide me.
TQ
|