Fill Down reference of even number rows

[jyorraku]

I have Excel 2002, I need to reference only even number row
coordinates, and I would like to do it with a fill down:

=B4
=B6
=B8
=B10
...
...


But if I select the first two cells and do a fill down, it duplicates
the coordinates?

=B4
=B6
=B6
=B8
=B8
=B10
=B10


HELP!

 

[Max]

Put this in the start cell (where you want: =B4)
=INDIRECT("B"&ROWS($1:1)*2+2)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik

 

[Teethless mama]

=OFFSET($B$4,(ROW(B4)-4)*2,0)

 

[Ron Coderre]

This formula references cell B4
and contains no volatile functions
(which re-calc whenever any other cell re-calcs and
can make a workbook sluggish):
A1: =INDEX(B:B,ROWS($1:1)*2+2)

Copy that formula into A2 and down as far as you need
to reference B6, B8....etc

Is that something you can work with?

Regards,

Ron Coderre
Microsoft MVP (Excel)