Formula for copying data for every 8th cell
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
|