Possibly

=CHAR(AVERAGE(CODE(A1:A10))

Adjust A1 - A10 to your used range and enter as an array
Ctrl+Shift+Enter

Mike

"Anita" wrote:

Hi

Is it possible to have a list of grades in a column as text i.e
A
A
B
C
D
A

and have Excel tell me which one is the average?

Thanks