copying formula by dragging

[Nunnu]

say, cell A3 is linked to A1.
Cell B3 is linked to C1.
Cell C3 is linked to E1
and so on.

Excel is not smart enough to recognize the pattern and so
if I drag the cell C3 over to D3, it won't know that D3
should be linked to G1

How can one do this, do I need a different formula like
offset or something like that?
Can anyone help please

Thanks

 

[Frank Kabel]

Hi
enter the following in A3
=OFFSET($A$1,0,(ROW()-1)*2)
and copy down

 

[Nunnu]

thnak you

-----Original Message-----
Hi
enter the following in A3
=OFFSET($A$1,0,(ROW()-1)*2)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


.