I have an excel sheet in column A it contains Name of the student and in column B it contains Marks of the students. Now I want the name of student in column C who gets the highest Mark.
I have an excel sheet in column A it contains Name of the student and in column B it contains Marks of the students. Now I want the name of student in column C who gets the highest Mark.
thank you
In Cell C2 enter:
=INDEX(A2:B6,MATCH(MAX(B2:B6),B2:B6,0),1)
"mangesh" wrote:
>
> I have an excel sheet in column A it contains Name of the student and
> in column B it contains Marks of the students. Now I want the name of
> student in column C who gets the highest Mark.
>
>
> --
> mangesh
>
>
> ------------------------------------------------------------------------
> mangesh's Profile: http://www.excelforum.com/member.php...fo&userid=6746
> View this thread: http://www.excelforum.com/showthread...hreadid=515079
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks