¹ï¤£°_ ½Ð°Ý¤@¤U¸Ó¦p¦ó«ç»ò¨Ï¥ÎVB?
- ©«¤l
- 11
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 15
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-2-22
- ³Ì«áµn¿ý
- 2014-5-2
|
¹ï¤£°_ ½Ð°Ý¤@¤U¸Ó¦p¦ó«ç»ò¨Ï¥ÎVB?
|
|
|
|
|
|
- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 243
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-10
|
¦^´_ 1# ¥d¹Å¶ð
¤F¸Ñ¤@¤Uµ{¦¡½X¤º®e- Sub ex()
- Set d = CreateObject("Scripting.Dictionary")
- ar = Range("A1").CurrentRegion '»PA1¬Û³sªº¸ê®Æ¼g¤J°}¦C
- For i = 1 To UBound(ar)
- If InStr(ar(i, 2), ",") > 0 Then 'n²¾°£«½Æ¸ê®Æ¦b²Ä2ÄæY¦³³rÂI¦s¦b«h°õ¦æ
- For Each ky In Split(ar(i, 2), ",") '¥H³rÂI¤À³Î¦r¦ê
- d(ky) = ""
- Next
- ar(i, 2) = Join(d.keys, ",") '¥H³rÂI³sµ²¦r¨åÃöÁä¦r
- d.RemoveAll '²¾°£¦r¨å¤º®e
- End If
- Next
- [G1].Resize(UBound(ar, 1), UBound(ar, 2)) = ar '©ñ¦bGÄæ
- End Sub
½Æ»s¥N½X |
|
¾Ç®üµL²P_¤£®¢¤U°Ý
|
|
|
|
|