the formula is copied from a working cell AA5 and is

=IF(OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16)=0,"",OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16))

watch for spaces etc in the post, but it does work.



apples72 Wrote:[color=blue]
I am now getting the error message, " you have entered too many
arguements
forthis function"

"Bryan Hessey" wrote:


To start in F5 set the initial to that, in AA5 copy / paste the
formula


=IF(OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16)=0,"",OFFSET($F$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16))

and in AB5 copy / paste


=IF(OFFSET($G$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16)=0,"",OFFSET($G$1,INT((ROW()+27)/8),(MOD((ROW()-5)/8,1))*16))

and formula-drag downwards



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:



--
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