View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kswarrier kswarrier is offline
external usenet poster
 
Posts: 1
Default to get the relative marks from a table of names,subjects & marks?

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