Hi, with help from Mr.Ardus Peter, sjoblom & philips, I manage to get some
information about formula for grading. But I still having problem.

my grades all at cell e.g A2:A35. (beside I enter grade A,B,C,D,E there is
also
simbol "-" and "x".('-' for not taking the subject and 'x' for absent)

I try this:
Average: =CHAR(ROUND(AVERAGE(CODE(A2:A35)),0))
Max: =CHAR(MIN(CODE(A2:A35)))

work fine. But when i enter simbol "-" or "x" it show #value.

Pls help me how to overcome this problem. TQ