| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to get the relative marks from a table of names,subjects & marks?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to get the relative marks from a table of names,subjects & marks?
Try the formula
b13=index($a$1:$g$11,match($a13,$a$2:$a$11,),match (b$12,$a$1:$g$1,)) a13 = Name of the student where a12:g12 heading viz name, subjects Just copy the formula from b13:g13 with regards sreedhar "kswarrier" wrote: hi, I have a table containing the marks of 10 students for 6 subjects .How to get the marks of a student for a subject by using an easy formula, if names are in cells a2:a11,subjects are in cells b1:g1 and marks in cells b2:g11. thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
to get the relative marks from a table of names,subjects & marks?
A mistake in the range
b13=index($a$1:$g$11,match($a13,$a$1:$a$11,),match (b$12,$a$1:$g$1,)) with regards Sreedhr "kswarrier" wrote: hi, I have a table containing the marks of 10 students for 6 subjects .How to get the marks of a student for a subject by using an easy formula, if names are in cells a2:a11,subjects are in cells b1:g1 and marks in cells b2:g11. thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Speech Marks in a table field | Excel Discussion (Misc queries) | |||
| How to align marks | Charts and Charting in Excel | |||
| Tally marks | Excel Discussion (Misc queries) | |||
| Quotation Marks? | Excel Worksheet Functions | |||
| without quotation marks? | Excel Discussion (Misc queries) | |||
Linear Mode
