In Excel. How do I drag (fill) a formula sequentially when the reference cells are populated every third row?

Question

Every time I try it it copies the formula and "skips" over 2 reference cells.
Ex.
Reference cells have in them:
X G G X G G X G G X G G

I want to drag fill to get:
X X X X

Does any of this make sense?
There are about 10 time a day when this would help me out tremendously!

Answer 1

Sure
You can use this formula (Assuming that your row is starting from A1 and the result is starting from B1), in B1 paste this:
=INDIRECT( ADDRESS( 1,(COLUMN( ) *2)+( COLUMN()-2)))

And fill it to the right until the end

Waoo, I am really the VBAXLMan

Answer 2

Either you are using absolute and relative references incorrectly. With absolute references you can lock the row $R or column $C or bother $R$C.
If this does not work, it is because the references cells are no aligned so wrong cells are being reference. You need to rearrange them. Simply drag the reference cells so they are top and bottom instead of side by side for right fill (or left, right for fill down).
If this does not work still, simply do as before, use control click to select the cells showing the wrong values and delete them.
Finally you can you also use if then constructs to get your spreadsheet to behave.

Answer 3

If the first two answers don't seem to solve your problem, it's probably because you haven't described it well enough. Are you talking about formulas, or just values. Give an example with cells specified.