Class Result In Excel
Solved/Closed
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
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
Related:
- School result software in excel free download
- Fc 24 free download - Download - Sports
- Microsoft store download - Download - App downloads
- Milfy city download - Download - Adult games
- Save as pdf software - Download - Other
- Five nights in anime download - Download - Adult games
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 28, 2010 at 05:10 AM
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.
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.
Nov 3, 2010 at 03:07 PM