Finding the Lowest Exam Grade

E

Eliot

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
 
R

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
 
L

Lori

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top