Greetings all,
I have a problems that would be great if someone could solve.
I've got a table that contains a number of dates and below that, an alphabetic grade that a person received on each date. I need to find a way to convert each alphabetic grade to a numeric grade and then get the average of that numeric grade to appear in the 'average' cell at the end.
I know how to convert alphabetic to numeric and have that result appear in another column, but I need to just have the average of all the grades appear and I don't want to add any new columns. I know it's possible, but I can't get it to work.
The alphabetic grades and their equivalents are: U=49.9, DC:62.5, VC=80, SC=90, EC=95.
I've attached a simplified version of the doc.
Thanks for your help in advance.
Cheers
Bookmarks