Posted to microsoft.public.excel.misc
|
|
dragging formulas
That worked for me. Thank you very much!
"Bryan Hessey" wrote:
Offset the column number by the number of rows above the firstline of
the drag,
ie, using c41+c87+c137+c184 in Row 9 and 'dragging' down would give
=OFFSET($C$41,0,ROW()-9)+OFFSET($C$87,0,ROW()-9)+OFFSET($C$137,0,ROW()-9)+OFFSET($C$184,0,ROW()-9)
and formula drag that downwards.
rmarks Wrote:
I am having a problem dragging down a formula. Its easier for me to
give an
example rather than describe the problem. Example: The formula im
trying to
drag down is: c41+c87+c137+c184. If i drag this down i will get
c42+c88+c138+c185 in the next row but the formula i result i would like
for
the drag down is d41+d87+d137+d184. Any thoughts on how i can correct
this?
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=486388
|