LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the row1 content of the existing excel file automically tlee Excel Worksheet Functions 2 April 28th 09 01:47 AM
How to get row2 value into row1 in calculated Field Column in pivo arun Excel Discussion (Misc queries) 0 March 31st 09 08:50 AM
VB Code is working for row1; how to apply to row2? moike Excel Programming 5 August 17th 06 07:50 PM
VBA to Identify changes in row1 Edmund Excel Programming 3 May 12th 06 06:42 AM
VBA dynamically format Row1 Liz Excel Programming 2 January 6th 06 09:15 PM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"