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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2855 users have said thank you to us this month

Thanks alot you have solved my problem!