½Ð°Ý¤@±Æ¼Æ¾Ú¥þ³¡´î1,¦ý¤£·Qnt¼Æ¸Ó¦p¦ó³B²z?
- ©«¤l
- 38
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-10
- ³Ì«áµn¿ý
- 2021-7-18
|
½Ð°Ý¤@±Æ¼Æ¾Ú¥þ³¡´î1,¦ý¤£·Qnt¼Æ¸Ó¦p¦ó³B²z?
½Ð±Ð¦U¦ì¦Ñ®v:
¤@±Æ¼Æ¾Ú¥þ³¡´î1,¦ý¤£·Qnt¼Æ¸Ó¦p¦ó³B²z?
A B C D E F G H I J K L M N O
1 3 2 0 0 4 2 1 1 2 3 3 0 1 2
¥þ³¡´î1 §Æ±æ¯àÅܦ¨
A B C D E F G H I J K L M N O
0 2 1 0 0 3 1 0 0 1 2 2 0 0 1
¥¿±`¨Ó»¡¥Î¤½¦¡,§Y¥i°¨¤W±o¨ìµª®×.¦ý¬O¼Æ¦r 0 ¥h´î1 ·|Åܦ¨-1,¤p§Ì§Æ±æ¼Æ¦r 0 ¥h´î1 ÁÙ¬O0.
¦pªG¼Æ¾Ú¬O±qA1~BJ1 ¥i¥Hª½±µ¥ÎVBAªºµ{§Ç³B²z¶Ü?
ÁÂÁÂ |
|
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É
|
|
|
|
|
- ©«¤l
- 48
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 64
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2000
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TAIPEI
- µù¥U®É¶¡
- 2011-4-16
- ³Ì«áµn¿ý
- 2018-9-26
|
A2=MAX(0,A1-1)
©¹¥k©Ô½Æ»s |
|
My Blog
http://blog.xuite.net/a8350070
|
|
|
|
|
- ©«¤l
- 38
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 84
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-12-10
- ³Ì«áµn¿ý
- 2021-7-18
|
¦^´_ 2# a8350070
TO:a8350070¤j¤j:
·PÁ±z«üÂI,§Ú±N¨äÂà´«¦¨vbs¨Ó¥Î¤F!
ÁÂÁ±z
Range("A2").Select
ActiveCell.FormulaR1C1 = "=MAX(0,R[-1]C-1)"
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:J2"), Type:=xlFillDefault
Range("A2:J2").Select |
|
·PÁ¦U¦ì¦Ñ®vªá¤ß«ä±Ð¾É
|
|
|
|
|