Big Excel problems in Canada!
Posted by Richard Larocque on February 06, 2002 9:32 AM
Alright! What I need to do is as follows: In C2:C14, let's say, there are scores. C1 is the average of these scores. The value in C1 which changes daily because the corresponding scores in C2:C14 change daily, must now appear in the B column. However, the values in the B column must always retain their values. For example, if on Jan. 1 the value in C1 is 40, the value in B2 is 40. If the value of C1 on Jan. 2 is 38, the value in B3 becomes 38 while the value in B2 remains at 40. Thanks.