ç¨å½æ°VLOOKUP+çéå¯ä»¥è§£å³ãä¹å¯ä»¥ç¨ä¸è½çvbaæ¥å®ç°ã
ç°ä¸¾ä¾ç¨vba解å³ã
åºæ¬æè·¯ï¼å建åå ¸B,å°Båæ°æ®åæ¾å°åå ¸Bä¸.éåæ°æ®Aåï¼å¦æåå ¸Bä¸ä¸åå¨å°±è¿½å å°Cåä¸ãéåç»æï¼åCåæ°æ®å³ä¸ºA-Bçç»æã
è¡¨æ ¼åå§æ°æ®å¦å¾ï¼
第ä¸æ¥ï¼å建å®ï¼å¹¶ç¼å¶ä»£ç å¦ä¸ï¼
Sub æ°æ®æé¤()
Dim mys As String
Dim I, J As Integer
Dim b As Object
mys = "æ°æ®æé¤"
Set b = CreateObject("Scripting.Dictionary")
Sheets(mys).Select
I = 2
Do While Cells(I, 2) <> "" 'å°ååæ¾å ¥åå ¸
m_key = Cells(I, 2)
M_ITEM = I - 1
If Not b.Exists(m_key) Then
b.Add m_key, M_ITEM
End If
I = I + 1
Loop
J = 2 'è®°å½Cååå ¥æ°æ®çææ°è¡å·
I = 2
Do While Cells(I, 1) <> "" 'å°Aåæ°æ®æé¤Båååå ¥Cå
m_key = Cells(I, 1)
If Not b.Exists(m_key) Then
Cells(J, 3) = m_key
J = J + 1
End If
I = I + 1
Loop
End Sub
è¿è¡è¯¥å®åï¼ç»æå¦å¾ï¼
亲,如果数据几万行,就不太适合用公式了,以下是VBA代码。附件已上传。
Sub bcf()
实在谢谢你,不过没看到你的回答,不然分就给你了,对不住啊!再次感谢!
追答没关系,如果公式太慢就试试这个