autofill @ intervals

  • Thread starter Thread starter jejkskpj
  • Start date Start date
J

jejkskpj

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.

Thanks,

JES
 
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...
 
Thanks


JE McGimpsey said:
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...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autofill results appear as "$ -" with no error, why? 2
autofill down won't work!!!! 3
Calculate average in intervals 1
Autofill 2
Autofill issue 10
Autofill 3
AutoFill with sheet reference help 6
formula that writes to a *different* cell? 4

Back
Top