formula

[Guest]

need to create a formula.

In Cell c230 = Cell c7
In Cell c231 = Cell c11
In Cell c232 = Cell c15
etc. How do I create a formula that I can copy and paste from cell c230 to
the other cells c231 thru c300.
Whe I reference =G7 in cell c230 and reference G11 in cell c230, copy and
paste gives me the incorrect formula.

Thank you for your help

 

[Guest]

Change C7:C200 to whatever your actual range is. Note that if your data and
this formula are in the same worksheet in Column C, there is not enough room
between C7 and C230 (ie you are trying to pull more data than can exist in
the range C7:C229)

=INDEX(C$7:C$200,(ROWS(C$230:C230)-1)*4+1)

 

[David Biddulph]

=OFFSET(G$7,4*(ROW()-ROW(C$230)),0)
but you may need to sort out whether you're looking at C7 or G7.

 

[Guest]

You need to understand the $. You can reference a cell as A1, $A1, A$1, and
$A$1. The $ doesn't change either the row or column when you do a copy an
paste. I think you want to put $G$7 in Cell c230. then copy C230 to C231
thru C300

 

[Guest]

Maybe I didn't explain this correctly.
c7 is a formula for c3:c6
I want to place the answer also in cell c230
c11 is a formula for c8:c10
I want to place the answer also in cell c231

Thank you again

 

[David Biddulph]

In which case, just change the G$7 in my formula to C$7.
In your original message you did say:
"Whe I reference =G7 in cell c230 and reference G11 in cell c230, ..."

 

[Guest]

This works very well.
Thank you
I will look on the internet to get a better understanding of how this works.
Excell help isn't clear, the explaination is to short.