Ãö©óScripting.Dictionary°£¤F¹LÂo«½ÆÈ¡A¬O§_¥i¥H¦P®É©¿²¤ªÅÈ¡H
- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2023-9-21
|
¦^´_ 1# av8d
«ØijªÅ¥Õ¥i¥Hª½±µ±Æ°£¡AÁÂÁ |
|
|
|
|
|
|
- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2023-9-21
|
¦^´_ 4# av8d
¦]¬°ªÅÈÀH®É·|³Q¶ñ¤J¸ê®Æ¡A©Ò¥H¬O§_¯à¼È®É©¿²¤¡A
¦ý¬O·í¶ñ¤J®É¡A´N·|ºâ¤J¡C
>>§ó§ï¦p¤U¡AÁÂÁÂ
For Each A In .Range("B4", .[B65536].End(xlUp))
If A.Value = "" Then GoTo 99
d(A.Value) = "" '¥u¨úBÄ椣«½ÆÈ
'd(A.Value) = IIf(d(A.Value) = "", A.Offset(, 1).Value, d(A.Value) & "," & A.Offset(, 1))
99: Next |
|
|
|
|
|
|