Drag formual to the right by every other column

[sdoppke]

Hi everyone, could someone help me figure out how to drag a simple "=A1" formula, so it increases by every other column?

i.e.
=a1
=c1
=e1
=g1

Thanks a ton, in advance!

sd

 

[AlphaFrog]

Try something like this...

=INDEX(1:1,1,COLUMN(A1)*2-1)

 

[sdoppke]

Try something like this...

=INDEX(1:1,1,COLUMN(A1)*2-1)

Youve bailed me out again AlphaFrog! I forgot to mention that the refereced row and columns are on another sheet. Is it the 1:1,1 that i adjjust for that? and also that i will be draging the formula down...
sd

 

[AlphaFrog]

References Sheet2 row 1 every other column as you drag down...

=INDEX(Sheet2!$1:$1,1,ROW(A1)*2-1)


Index will reference a cell within a defined range based on row\column index numbers. If the defined range is Row 1 then for example index 1, 3 of that range would be cell C3.

This part of the formula...
ROW(A1)*2-1
...simply increases the column index by 2 as you drag the formula down.

Put this formula in any cell and drag it down to see how it increments the column index number.
=ROW(A1)*2-1

 

[AlphaFrog]

If the defined range is Row 1 then for example index 1, 3 of that range would be cell C3.

Correction:
Should read C1 and not C3

 

[sdoppke]

Correction:
Should read C1 and not C3

Exactly what i needed!! thanks for taking the time to teach as well.

 

[stevebrooks01]

Dear id107

could you cast your eye upon this one kind Sir if you get a chance

http://www.mrexcel.com/forum/showthread.php?t=581152

much appreciated
Steve
UK