ExcelBanter - functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - functions (https://www.excelbanter.com/excel-worksheet-functions/83127-functions.html)

rami

functions

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

Duke Carey

functions

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

"rami" wrote:

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

All times are GMT +1. The time now is 11:52 AM.