View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newtomitch newtomitch is offline
external usenet poster
 
Posts: 2
Default Proprogate column calculations from row1 to rownn

I am trying to create a Master Grade table where a test may have a diffierent
number of questions, so wanted to set up row 1 than use it to create
additional rows up to number of questions on the test.

Compute percentage correct for 50 question text;
50 questions 50 answered right 100%
50 questions 49 answered right nn%
....
50 questions 1 answered right nn%

Can someone please suggest a method to replicate a cell computation to
additional rows when the number of rows required will be different use of
this workbook.

Thank yoiu.