filling in contents with a step.

**demyan** · 05-12-2009, 10:00 AM

Dear All,

It took me two days to make this manually, and I really need your help since three of such tasks are still to go..

I am using a Ctrl-Shift-Enter function to get the products of adjacent cells. For me it looks as follows:

=F584:F1166*G584:G1166 (with braces).

So, say, this will be the content of one of the column. In the adjacent column to the right I want to place the results of the following:

=F583:F1165*G584:G1166,

then in the next:

=F582:F1164*G584:G1166,

and so on till

=F2:F582*G584:G1166.

What I did was manual modification in the formula bar and analysing the results. I would very much appreciate if you could tell me how I can do this automatically. I cannot program and suspect that I have to in order to accomplish this. Is there some kind of a step function in order to do this?

Thank you very much,

demyan

**zbor** · 05-12-2009, 10:04 AM

Use $ at second range: F584:F1166*$G$584:$G$1166 and extend down as you need

**martindwilson** · 05-12-2009, 10:37 AM

{=F3:F5*G4:G6} gives the same result as =f3*g4 why the array?

**demyan** · 05-12-2009, 11:14 AM

Sorry for being a bit unclear, and thank you both for replies.

I will simplify the setup a bit.

1) Say, there are two vectors of variables: A4:A7 and B4:B7.

2) In C4:C7 I want to place the corresponding products of each cell (A4*B4, A5*B5, etc.).

3) In D4:D7 I want to place the products of the lags of A vector variables and today's values of B vector. This looks like: A3:A6*B4:B7.

4) Of course there will be some N/As starting from D (e.g. D4 will be N/A because there will be no lagged content in A3).

5) There will naturally be four such columns (C,D,E,F).

6) Since I want all of the column cells to have the same formula, I make it CSE formula for a column.

Question: How can I make this automatically so that I would just drag the range C4:C7 to the right and get all of these (D,E,F, all 4 to 7)?

Thank you very much again. I really need your help, this is for my MA thesis.

demyan.