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

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!