|
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
|