When dragging formula down the formula skips x number of cells

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