Average Grade for Letters
=CHAR(AVERAGE(CODE(A1:A9))) entered as an array formula (Control Shift
Enter).
--
David Biddulph
"andreah" wrote in message
...
I have a column of values which are all grades A to U and I would like to
work out the Average of that column but can only figure out how to average
numbers. Is there anyway of averaging a column of letter values?
|