½Ð±Ð¦p¦ó¤ñ¹ï¸ê®Æ¡A¨Ã§ó·s¡C
- ©«¤l
- 9
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 56
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- KEELUNG
- µù¥U®É¶¡
- 2010-7-23
- ³Ì«áµn¿ý
- 2024-9-28
|
½Ð±Ð¦p¦ó¤ñ¹ï¸ê®Æ¡A¨Ã§ó·s¡C
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 239
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-4
|
¦^´_ 1# alpha - Sub nn()
- Set d = CreateObject("Scripting.Dictionary")
- Set d1 = CreateObject("Scripting.Dictionary")
- For Each a In Range([A2], [A2].End(xlDown))
- d(a.Value) = a.Offset(, 1).Value
- d1(a.Value) = a.Offset(, 2).Value
- Next
- For Each a In Range([H2], [H2].End(xlDown))
- a.Offset(, 1) = a.Offset(, 1).Value + d(a.Value)
- d.Remove a.Value
- a.Offset(, 2) = a.Offset(, 2).Value + d1(a.Value)
- d1.Remove a.Value
- Next
- For Each ky In d.keys
- [H65536].End(xlUp).Offset(1, 0).Resize(, 3) = Array(ky, d(ky), d1(ky))
- Next
- End Sub
½Æ»s¥N½X |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|
- ©«¤l
- 9
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 56
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- OFFICE2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- KEELUNG
- µù¥U®É¶¡
- 2010-7-23
- ³Ì«áµn¿ý
- 2024-9-28
|
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|