Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Can you change the relative reference of a cell in an Excel formul | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
Object class in Excel VBA | Excel Discussion (Misc queries) | |||
Format Excel column as Upper Case without use of UPPERCASE formul | Excel Discussion (Misc queries) |