View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Fill Down reference of even number rows

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
---
"jyorraku" wrote in message
...
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!