|
- Sub pey_test()
- Dim arr(), d As Object
- Set d = CreateObject("Scripting.Dictionary")
-
- arr = Sheet1.Range("a1").CurrentRegion.Value
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = d(arr(i, 1)) + 1
- Next
- '''''''''''
- Dim brr, k0
- With Sheet2
- k0 = .[a65535].End(3).Row
- brr = .[a1].Resize(k0, 1)
- End With
-
- '''''''''''''''
- For i = 1 To k0
- temp = Trim(brr(i, 1))
- If Len(temp) > 0 Then
- For Each ma In d.keys
- If InStr(ma, arr(i, 1)) Then d.Remove (ma): Exit For
- Next
- End If
- Next i
-
- Sheet3.Range("a:a").ClearContents
- Sheet3.Range("a1").Resize(d.Count) = Application.Transpose(d.keys)
- End Sub
复制代码 略作修改
|
评分
-
1
查看全部评分
-
|