ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

³]
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?

¦^´_ 1# v60i


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

Book1.zip (7.45 KB)

TOP

¦^´_ 2# register313


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

TOP

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

TOP

¦^´_ 5# ANGELA


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

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD