Copying fomula down...

Jambruins · Jan 18, 2006

I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I know if the
cells equaled A2, A3, A4 I could just drag it down but it doesn't work in
this case. Any ideas? Thanks

Chip Pearson · Jan 18, 2006

Try the following formula

=INDIRECT("A"&ROW()*2)

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
news:[email protected]...

Jambruins · Jan 18, 2006

Actually this is what the exact cells are:

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

Biff · Jan 18, 2006

Hi!

Try this:

=INDEX(odds!C:C,(ROWS($1:2)-1)*2)

Biff

pinmaster · Jan 18, 2006

Try:

=INDIRECT("ODDS!C"&ROW(1:1)*2)

HTH
JG

Jambruins said:
Actually this is what the exact cells are:

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

Jambruins · Jan 19, 2006

chip, biff, and pin, thanks for the help!

pinmaster said:
Try:

=INDIRECT("ODDS!C"&ROW(1:1)*2)

HTH
JG