Try these:

=IF(INDEX($5:$5,ROWS($1:3)*2)=0,"",INDEX($5:$5,ROW S($1:3)*2))

AND

=IF(INDEX($5:$5,ROWS($1:3)*2+1)=0,"",INDEX($5:$5,R OWS($1:3)*2+1))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"apples72" wrote in message
...
I am getting an error in the formula... does it matter that I am actually
starting in cell F5 and G5.

That way, cell AA5=F5, AA6=H5
and AB5=G5, AB6=I5, etc....


"Bryan Hessey" wrote:


If I have understood correctly, column AA to have A1, C1, E1 etc and the
other B1, D1, F1 onwards, try

=OFFSET($A$1,INT((ROW()-1)/8),(MOD((ROW()-1)/8,8)-INT((ROW()-1)/8))*16)

and

=OFFSET($B$1,INT((ROW()-1)/8),(MOD((ROW()-1)/8,8)-INT((ROW()-1)/8))*16)



apples72 Wrote:
I have a worksheet that is 16 columns long, and 40 rows down, and in
every 2
columns, there are 2 items that relate to the next 2, etc.

e.g. A1, C1, E1, G1, I1, K1, M1, O1 are the one related item,
B1, D1, F1, H1, J1, L1, N1, P1 are another related item, and so on.

Is there a way to modify this Column Helper so that it will enter
every
other column, say AA1:300, and then use it again in another column,
say
AB1:300


=IF(OFFSET(A$1,INT((ROWS($1:1)-1)/16),MOD(ROWS($1:1)-1,16))=0,"",OFFSET(A$1,
INT((ROWS($1:1)-1)/16),MOD(ROWS($1:1)-1,16)))


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=484621