software

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: www.excelforum.com/member.php...foamp;userid=6746
View this thread: www.excelforum.com/showthread...hreadid=515079In Cell C2 enter:

=INDEX(A2:B6,MATCH(MAX(B2:B6),B2:B6,0),1)quot;mangeshquot; wrote:

gt;
gt; I have an excel sheet in column A it contains Name of the student and
gt; in column B it contains Marks of the students. Now I want the name of
gt; student in column C who gets the highest Mark.
gt;
gt;
gt; --
gt; mangesh
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mangesh's Profile: www.excelforum.com/member.php...foamp;userid=6746
gt; View this thread: www.excelforum.com/showthread...hreadid=515079
gt;
gt;