Excel Formulas, Who got highest mark in class? looking for formul

[Wali]

Who got highest mark in class? looking for formul for the spread sheet.
OR if there are 4 sections which section got the highest mark and who got
the highest mark in that section?
looking for formula
thanks

 

[T. Valko]

Based on the amount of info you provided about all I can suggest is to look
in Excel help for the MAX function.

To get a more useful suggestion you need to provide a lot more detail.

 

[Jay Dee]

Paste the structure Name & Marks in A1 & B1 cells respectively. Under Highest
Marks field ie. pasted in C1 cell, use LARGE() or MAX() to get the highest
marks. Under Person field pasted in D1, use the following formula i.e.
=INDEX($A$1:$B$4,MATCH(C2,$B$1:$B$4,0),1) to get the name of the person.
Please paste sample data under the fields copied in A1, B1.


Name Marks Highest Marks Person
A 10 39 C
B 29
C 39