[µo°Ý] ½Ð°Ý¦p¦ó¦bexcel¤¤«ü©w±Æ¦C¥X²{ªº¦¸¼Æ©O

v60i

³]
b5=5
b6=1
b7=2
b8=20
¦p¦ó¥i¥HÅý
c3=1
c4=1
c5=1
c6=1
c7=1
------c3~c7 ¦@¥X²{b5«ü©wªº¼Æ¦r5¦¸-------
c8=c3+b7
c9=c4+b7
c10=c5+b7
c11=c6+b7
c12=c7+b7
------c8~c7 ¦@¥X²{b5«ü©wªº¼Æ¦r5¦¸-------
C13=C8+B7
.
.
.
c22=c17+b7
------c3~c22 ¦@¥X²{b8«ü©wªº¼Æ¦r20¦¸-------

½Ð°Ý¸Ó¦p¦ó¼g?

register313

¦^´_ 1# v60i


    ¬O³o¼Ë¶Ü ¤£À´³o­n§@¤°»ò¥Î

v60i

¦^´_ 2# register313


    ¤j¤j ¦³¿ìªk¥ÎEXCEL¤½¦¡¼g¶Ü?
¥ÎVB¼g ªº½T¨S¤°»ò¥Î³B

ANGELA

C3=IF(ROW(A1)>$B$8,"",IF(ROW(A1)<=$B$5,$B$6,OFFSET($C$2,ROW(A1)-$B$5,)+$B$7))

v60i

¦^´_ 5# ANGELA


    ÁÂÁª©¥D
¥Î¤½¦¡¹ï§Ú´N¦³¶W¥Îªº