formula for finding best GCSE grade

Hi

hope someone can help, i was asked by maths teacher if i knew how to find best GCSE grade in spreadsheet, e.g. a student has sat a maths exam in Nov and then Jan, and maybe has a predicted grade. find the best grade from the 3 coloumns but could be even more coloumns depending on how many assessments the student has done. grades will be A-G, U, X.

thanks in advance

H

Hi, i have attached a file to better explain what i mean, thank you

Izandol's solution works like a charm, just use B2:D2 instead of A1:M1

Sorry, do i enter the code =IFERROR(CHAR(MIN(CODE(UPPER(B2:D2)))),"") in cell E2?

i just tried this but get a blank cell, but when i click on fx it is showing formula result as correct, e.g. first row as A

thanks

You probably forgot to confirm the formula with Control+Shift+Enter. (Not just Enter.)

thanks Izandol and estige it was my mistake bt not Ctrl+Shift+Enter.

just want to check if i understand the code, CHAR = ABC, etc and min would be starting from A, upper = Z

is it possible for this to work if the grades coloumns are not next to each other and theres other coloumns inbetween that might have numbers but i dont want to use them.

Here is one possibility if you want to look up cells that are not in a range (e.g. col B, D and F in stead of B, C and D):
=IFERROR(CHAR(MIN(CODE(UPPER(B2)),CODE(UPPER(D2)),CODE(UPPER(F2)))),"")
(Still array)

thanks to everyone for the help