Harald,
Thank You very much for the formula...you are correct not every
8th but nontheless you answered my question. Thanks!!!!
I would like to ask a couple of questions of how the formula works. I
understand the "If" function of the formulas but I am unfamiluar with the
following.
=if(MOD(ROW(),8)<1,"",INDIRECT("A"&(1+INT(ROW()/8))))
MOD-- What is this telling excel to do?
()--What does this tell excel to do?
<--What does this tell excel to do?
Indirect--What does this tell excel to do?
1+INT--What does this tell excel to do?
()/8--What does this tell excel to do?
Thank You,
Judd
"Harald Staff" wrote:
Hi Judd
=IF(MOD(ROW(),8)<1,"",INDIRECT("A"&(1+INT(ROW()/8))))
(Note that 1-8-16 is not every 8th)
HTH. Best wishes Harald
"jbsand1001" skrev i melding
...
Hello,
I am looking for a formula that will allow me to copy either text
or
numerical data in sequence for every 8th cell. The problem that I have is
that excel uses the relative/absolute reference and copies cells in
sequence.
Example:
A1:A20=1-20 B1=1,B2="",B3=""....B8=2,B9="",B10="",B16=3
A1=1 B1=1
A2=2 B2=""
A3=3... B3="".
A20=20 B8=2
B9=""
B10="".
B16=3
Thank You,
Judd
|