Finding the Lowest Exam Grade

[Guest]

Help Please

I have a spreadsheet with all the predicted grades of students A*-G i need
to find the lowest grade achieved by the student. Can anyone help please

 

[Roger Govier]

Hi

Ignoring the * of A*, the following array formula should work
{=CHAR(MAX(CODE(A8:F8)))}

To commit or edit an array formula, use Control+Shift+Enter (CSE) not
just Enter.
Do not type the curly braces { ] yourself, Excel will ad them when
you use CSE

 

[Lori]

One way, if grades are in G1:G10 try entering

=LOOKUP(2,1/(COUNTIF(G1:G10,">"&G1:G10)=0)/(G1:G10<>""),G1:G10)