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

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

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

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.

--
Biff
Microsoft Excel MVP


"Wali" wrote in message
...
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

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

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


"Wali" wrote:

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