Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions
if i have a column for student's name and other for their grades. how can i
find using functions the name of student who have the highest grade |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions
What about ties for the highest grade?
If only one can have the highest grade: =INDEX(A8:A12,MATCH(LARGE(B8:B12,1),B8:B12)) where the names are in A8:A12 & grades are in B8:B12 "rami" wrote: if i have a column for student's name and other for their grades. how can i find using functions the name of student who have the highest grade |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions |