I created a Formula, OK, but can't get the results in the righ
Well, I like that. I understand it a little better. Not as confusing
Thak you for the help
"T. Valko" wrote:
Or this non-volatile version:
=INDEX(G$7:G$200,1+(ROWS($1:1)-1)*4)
Adjust for the end of range
Biff
"T. Valko" wrote in message
...
One way:
Enter this formula in G230 and copy down as needed:
=OFFSET(G$7,(ROWS($1:1)-1)*4,,)
Biff
"To Old To . . ." wrote in message
...
Created Formula for G7
=SUM(G4:G6)
and have copied it to other cells, i.e.
G11
=Sum(G8:G10), etc
- This Works Fine
Now what I want to do is:
the answer of G7 in cell G230
the answer of G11 in cell G231, etc
How can I do this.
If I copy and past I get G7 in cell G230, then I get G8 in cell G231, not
G11
Thank you for your help.
|