Class Result In Excel

Solved/Closed
Report
-
 . -
Hello,
I have worksheet of class result.In column A there are names of students.
In column B i have marks.
I want a formula which tell me the name of person which get highest marks.
Kindly answer ASAP.
Thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
suppose the student name and marks are given from A1 B1 down as follows

studen marks
a 76
s 48
d 86
f 90
g 36


in an empty cell type this formula

=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0),1)

you will get f. that is student f got mcx mark.
4
Thanks alot you have solved my problem!
0