Quote:
Originally Posted by pjphilli
Thanks all for your help.
A further question. I can work this by putting the formula into the lower rows of C by typing it in each time. Since I have a lot of rows involved is there some way I can copy the formula into all the rows of C
(whilst automatically changing the number indicated of row B) in one action?
(Tried various things which don't work).
Cheers Peter
|
An easy way for this is to select the first cell with the formula in it and you will notice when you move the mouse to the bottom right hand corner of that cell, there is a little black square and the mouse cursor will change to a plus symbol. Simply click and drag this down to all cells with the mouse. The formula will auto copy and reflect the correct cell calculations.
Cheers