functions

G

Guest

if i have a column for student's name and other for their grades. how can i
find using functions the name of student who have the highest grade
 
G

Guest

What about ties for the highest grade?

If only one can have the highest grade:

=INDEX(A8:A12,MATCH(LARGE(B8:B12,1),B8:B12))

where the names are in A8:A12 & grades are in B8:B12
 

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

Similar Threads

Counting multiple memberships 1
Need formula to do the following... 4
Possible If Function? 3
Conditionally summing cells based on conditions in other rows 3
Conditional Formatting 1
Automatic emailing Excel content via Outlook (for Student grading) 2
Adding cels in a row that correspond to the heading of a column 2
Saving a value in another cell 1

Top