Class Result In Excel

Solved/Closed
mbbs - Oct 24, 2010 at 01:09 PM
 . - Nov 3, 2010 at 03:07 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 28, 2010 at 05:10 AM
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