|
|
Changing the Helper Column
The formula was setup for AA1, if you start in AA1 abd AB1 and drag down
from there it should be ok
Otherwise the column offset will be in error
apples72 Wrote:
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
--
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
|