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