Good to see, and thanks for the reply.
apples72 Wrote:[color=blue]
Thanks, it worked... once I realized I was missing a few brackets!
"Bryan Hessey" wrote:
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:
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
--
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