[¤w¸Ñ¨M][µo°Ý]µ{¦¡Â²¤Æ-°}¦C-VBA ¡A´M§ä¬Y¤¸¯À¬O§_¦s¦b°}¦C¤¤¡C
- ©«¤l
- 132
- ¥DÃD
- 25
- ºëµØ
- 0
- ¿n¤À
- 199
- ÂI¦W
- 0
- §@·~¨t²Î
- window XP
- ³nÅ骩¥»
- Excel 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW ·s¦Ë
- µù¥U®É¶¡
- 2010-6-1
- ³Ì«áµn¿ý
- 2022-7-14
|
chin15 ÁÂÁ¡C±q§A¦^µªªº°ÝÃD¡Aı±o§A¬O±j¤â¡A¤w¸g±q¤p¾Ç¥ÍÂର¤¤¾Ç¥Í¤F¡AÁÂÁ¡Cµ{«×¥»¨Ó´N¤£À³¸Ó¬O¤p¾Ç¥Í¡C |
|
|
|
|
|
|
- ©«¤l
- 45
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 59
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-6
- ³Ì«áµn¿ý
- 2019-6-22
|
¦^´_ 5# GBKEE
GBKEE«e½ú¦n,«_¬N¥´ÂZ,
·PÁ´£¨Ñµ{¦¡½X,
¤p§Ì¦³¸ÕµÛקï«e½úªºµ{¦¡½X,
¸Õ¹Ï±NÀx¦s®æ¤ºªºÈ°µ¬°¤¸¯ÀÀx¦Ü°}¦C¤¤,¦ý¬O·|¥X²{¿ù»~,¤£ª¾¦p¦ó¸Ñ¨M,
¤p§Ì¤æÁx,¬O§_¯à°÷³Â·Ð«e½ú«üÂI°g¬z,¤Q¤À·PÁÂ.
ªþ¤WÀɮפÎקï¦Û«e½ú©Ò¼gµ{¦¡½X:- '¦¹µ{¦¡½Xקï¦Û³Â»¶®a±Ú°Q½×°Ïexcel°ª¤âGBKEE«e½ú©Ò¼g,«D§Ú¦Û³Ð.
- '°Q½×°Ïºô§}:http://forum.twbts.com/index.php
- Sub Ex()
- A = Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row)
- b = Range("b2:b" & Cells(Rows.Count, 2).End(xlUp).Row)
- For Each E In A
- M = Application.Match(E, b, 0)
- MsgBox E & IIf(IsNumeric(M), "¦s¦b©ó ", " ¤£¦s¦b©ó ") & Join(b, ",")
- Next
- End Sub
½Æ»s¥N½X
20161026-°}¦C·j´M¯S©w¦r¦ê°ÝÃD.zip (9.06 KB)
|
|
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 13# greetingsfromtw - '°Q½×°Ïºô§}:http://forum.twbts.com/index.php
- Option Explicit
- Sub Ex()
- Dim M As Variant, A(), B()
- A = Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) '¤Gºû°}¦C
- B = Range("b2:b" & Cells(Rows.Count, 2).End(xlUp).Row) '¤Gºû°}¦C
- B = Application.WorksheetFunction.Transpose(B) 'Âà¦Ü¬°¤@ºû°}¦C
- For Each E In A
- M = Application.Match(E, B, 0)
- MsgBox E & IIf(IsNumeric(M), "¦s¦b©ó ", " ¤£¦s¦b©ó ") & Join(B, ",")
- 'Join ¨ç¼Æ ¶Ç¦^¤@Ó¦r¦ê¡A¸Ó¦r¦ê¬O³z¹L³sµ²¬YÓ°}¦C¤¤ªº¦hÓ¤l¦r¦ê¦Ó«Ø¥ßªº¡C
- '******** ¬YÓ°}¦C ,¥²¶·¬O¤@ºû°}¦C********************
- Next
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 45
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 59
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-2-6
- ³Ì«áµn¿ý
- 2019-6-22
|
¦^´_ 14# GBKEE
«D±`·PÁÂGBKEE«e½ú¸Ô²Ó¸Ñ»¡,
ì¨Ó°ÝÃD¥X¦b¤@ºû°}¦C,¤p§Ì¦A¬ã¨s¬Ý¬Ý. |
|
|
|
|
|
|
- ©«¤l
- 37
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 72
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- 0
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2020-7-23
- ³Ì«áµn¿ý
- 2022-5-27
|
¦^´_ 3# chin15 - a = Array("¤@", "¤", "¤K")
- b = Array("¤@", "¤G", "¤T", "¥|", "¤", "¤»")
- For i = 0 To UBound(a)
- If UBound(Filter(b, a(i))) = -1 Then
- MsgBox "¤£ ¥]§t" & a(i)
- Else
- MsgBox "¥]§t" & a(i)
- End If
- Next
½Æ»s¥N½X ½Ð°Ý¸Ó«ç»ò¼Ë°µ¤~¯à¶i¤@¨BÅã¥ÜA¬O¦s¦bB°}¦Cªº²Ä´XÓ¯Á¤ÞÈ©O?
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 254
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 310
- ÂI¦W
- 0
- §@·~¨t²Î
- W10
- ³nÅ骩¥»
- Excel 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2019-6-16
- ³Ì«áµn¿ý
- 2024-9-23
|
¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2020-8-12 20:10 ½s¿è
³o¼Ë¦n¹³¤]¥i¥H- Sub ½m²ßÅã¥Ü°}¦C¦ì¸m()
- Dim A, B, i, k
- A = Array("¤@", "¤", "¤K")
- B = Array("¤@", "¤G", "¤T", "¥|", "¤", "¤»")
-
- For i = 0 To UBound(B)
- If A(k) = B(i) Then
- MsgBox " Aªº " & A(k) & " ¦b B ªº ²Ä " & i & " Ó"
- If k <= UBound(A) Then k = k + 1
- Else
- MsgBox " B ªº ²Ä " & i & " Ó" & " ¬O " & B(i)
- End If
- Next i
-
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 2833
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2889
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-11
|
¦^´_ 16# ssooi
¥i¥H¨Ï¥Î APPLICATION.MATCH
°}¦C¼Æ¶q¤j ¦r¨å--ITEM°O¿ý¦ì¸m |
|
|
|
|
|
|