When dragging formula down the formula skips x number of cells

Hello everybody,

Is it possible to write a formula that skips x number of cells and have the formula autoincrement as usual. For an examples lets say I want to skip 3 cells and I have entered in the cells listed:
A1= "1"
A2= "2"
A3= "3"

Then I type in the simple formula in the cell
B1= "=A1"

and then drag down but it skips 3 cells so then

B5= "=A2"

B9= "=A3"

If it didn't skip then
B1= "=A1"
B2= "=A2"
B3= "=A3"

this is just an example as I will be writing more complex formulas and need some thing that I can write into the formula so that it skips.

Something similar to this B1 "=A1(skip3cells)"

Thanks for helping

Originally Posted by Pepe Le Mokko

And what should appear in B2,B3 and other cells inbetween?

Basically nothing

Originally Posted by Ron Coderre

Using your example...
This regular formula, copied down, references consecutive cells, skipping two rows between calculations:

B1: =IF(MOD(ROW()+2,3),"",INDEX(A:A,ROW()/3+1))

Is that something you can work with?

Yes, that does work.

Thanks for helping