View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jejkskpj jejkskpj is offline
external usenet poster
 
Posts: 2
Default autofill @ intervals

Thanks


"JE McGimpsey" wrote in message
...
Can't use autofill, but if you enter

B1: =INDEX(A:A,ROW()*3-2)

You can copy the formula down as far as required...



In article ,
"jejkskpj" wrote:

What to be able to return A1 then A4 then A7 and so on in the cell. How
do
you do this beside writing the formula. Want to be able to use the
autofill
at intervals.