Something like
=CHAR(ROUND(AVERAGE(IF((CODE(A2:A10)=65)*(CODE(A2 :A10)<=69),CODE(A2:A10))),0))
array entered
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"Param" wrote in message
...
Hi Mr.Ardus Petus,
solution that u provide really help me a lot. but i face new problem when
i
enter - or x symbol. Actually i enter grade from range A to E. Beside that
i
enter x if the student absent. - for not sitting the paper.
any idea?
"Ardus Petus" wrote:
I forgot to point out these are array formulas, to be validated by
Ctrl+Shift+Enter
--
AP
"Ardus Petus" a écrit dans le message de
...
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