In row 1 I have data in every other cell (A,C,D,E,G,I,K and so on) when I go
in row 3 and in A3 tell it that it equals A1 and B3 tell it that it equals C1
and then select the two and drag them across it is making its own sequence
for the formula repeating column references. How do I set it to follow my
pattern of skipping every other cell in row 1.

Row 3 fromula should be where A3=A1, B3=C1,C3=E1, D3=G1 and so on.

Thank you

Hi,

In A3 enter

=OFFSET(A1,,COLUMN()-1)

Copy this across.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jeremy" wrote:

In row 1 I have data in every other cell (A,C,D,E,G,I,K and so on) when I go
in row 3 and in A3 tell it that it equals A1 and B3 tell it that it equals C1
and then select the two and drag them across it is making its own sequence
for the formula repeating column references. How do I set it to follow my
pattern of skipping every other cell in row 1.

Row 3 fromula should be where A3=A1, B3=C1,C3=E1, D3=G1 and so on.

Thank you