referencing other cells

[esung]

I want to reference every other cell doing down on the column next to it.
ie. i want the formula in b1 to =A1, b2 =A3, b3 =A5, b4 =a7, etc.. etc.. etc...

is there an easy way to do this instead of hand typing in all the forumlas

[Mark@Work]

There may be better ways, but this works...

Assuming your data is in A1:A1000
and you want your new column to start at B5

B5 to B505 : = OFFSET(A$1,(ROW()-5)*2,0)

The row offset should count 0, 2, 4, ....

Mark.

[esung]

thanks a lot, the formula is real nice