Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formulas
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formulas
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formulas
Hi,
Try, =OFFSET($A$1,40,ROW(A1)+1)+OFFSET($A$1,86,ROW(A1)+ 1)+OFFSET($A$1,136,ROW(A1)+1)+OFFSET($A$1,183,ROW( A1)+1) Here, the number after the comma immediately after $A$1 in each OFFSET function is one less than the row number of the cell added. Regards, B. R. Ramachandran "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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formulas
The only way I know to get the results you want is to drag horizontally.
Then 'Cut' and 'Paste' in Column you tried to drag down. TC "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? |
#5
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
dragging formulas
Thanks for the reply. rmarks Wrote: 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 -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging formulas | Excel Worksheet Functions | |||
copy formulas by dragging vertically | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Dragging formulas | Excel Worksheet Functions | |||
Dragging formulas | Excel Worksheet Functions |