formula
 

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

formula
 

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)



"To Old To . . ." wrote:

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

formula
 

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

"To Old To . . ." wrote in message
...
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

formula
 

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

"To Old To . . ." wrote:

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

formula
 

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" wrote:

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

"To Old To . . ." wrote in message
...
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

formula
 

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, ..."
--
David Biddulph

"To Old To . . ." wrote in message
...
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" wrote:

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

"To Old To . . ." wrote in message
...
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

formula
 

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.

"David Biddulph" wrote:

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, ..."
--
David Biddulph

"To Old To . . ." wrote in message
...
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" wrote:

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

"To Old To . . ." wrote in message
...
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