- ©«¤l
- 28
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 43
- ÂI¦W
- 0
- §@·~¨t²Î
- window
- ³nÅ骩¥»
- office 2000
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- ¨Ó¦Û
- Hong Kong
- µù¥U®É¶¡
- 2011-1-14
- ³Ì«áµn¿ý
- 2021-8-27
|
¦p¦ó¥[¦æ¤Î±N¸ê®Æ¥[Á`
½Ð°Ý¦U¦ì, ¥»¤H¦³¤@Ó¬ã¨s¤F«Ü¤[ªº°ÝÃD¥¼¯à¸Ñ¨M... §Æ±æ¦U¦ì¯àÀ°À°¦£¸L
¥»¤H»Ýn±N©Ò¦³¦P¤@Ó½s¸¹ªº¼Æ¦r¥[Á`, ¦p¤U¤È
A B
number amount
1 123 $981
2 123 $451
3 123 $657
4 123 $891
5 124 $541
6 124 $321
7 125 $254
8 126 $986
9 126 $654
10 126 $666
11 127 $456
12 128 $444
¦p¬OªÌ¦Ü´X¦Ê¦æ¡A¦ý§Ú»Ýn±N¦P¤@½s¸¹ªº¥[Á`¡A©ó¬O»Ýn¦b¤¤¶¡¥[¤@¦æ¡A¨Ã¥[Á`... ¦ý¥»¤H¹Á¸Õ«Ü¤í³£¤£¦¨¥\.. ¤jP¦p¤U¤È
temp_data = sheets("½s¸¹").usedrange
for i = 1 to ubound(temp_data)
if range("A" & i) <> range("A" & i + 1) then rows(i +1).insert
for j = 1 to ubound(temp_data)
if range("A" & j) <> range("A" & j + 1) then
myrow = j
exit for
end if
next j
range("B" & i +1).formula = ="sum(R[-1]:R" & myrow &")"
end if
next i
¦ý«Y¤£¦¨¥\.... ¤¤¶¡¥i¥H¥[¦æ, ¦ý¤£¯àÃѧOSUMUP¥Ñ¨º¤@¦æ¥[¦Ü¨º¤@¦æ...¥»¤H¬O·s¤â¤@¦W... ½Ð¦U¦ì¦h¦hÀ°¦£..
¥»¤H´¿¸g·Q¥Î do until ..... loop ¤§Ãþ... ¦ýøª¾ÂI¼g |
|