Class Result In Excel

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

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


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