Excel help, autofill pattern?
In Cell G20 I have: =(Sheet4!C8-Sheet4!C7)/Sheet4!B7
In Cell G21 I want: =(Sheet4!D8-Sheet4!D7)/Sheet4!D7
In Cell G22 I want: =(Sheet4!E8-Sheet4!E7)/Sheet4!E7
How do I make it so I can just drag from cell G20 down to make it autofill how I describe above. Thanks
Update:You are a life-saver.
More Questions From This User See All
Answers & Comments
Verified answer
is that a typo?
on the far right (where you are dividing)....you want
Sheet4!B7 then to Sheet4!D7 then to Sheet4!E7
should the B7 really be C7?
besides that, you are dragging down, but you want the columns to change? that would require the INDIRECT() function or the OFFSET() function.
easy enough, but i would need to know if the 1st one is a typo....if its not a type, then i wouldnt know the pattern.
edit-
ok, that makes sense.
i will use the OFFSET()
copy&paste this
=(OFFSET(Sheet4!C$8,0,ROW(C1)-1)- OFFSET(Sheet4!C$7,0,ROW(C1)-1))/ OFFSET(Sheet4!C$7,0,ROW(C1)-1)
then drag down
the ROW(C1)-1 part changes the Column by 1 as you drag down.
it should just work. let me know if it doesnt.
i like the indirect better
heres a link to Chip Pearsons INDIRECT() tutorial, the 1st paragraph and the last paragraph apply to you.