|
楼主 |
发表于 2012-9-7 21:23
|
显示全部楼层
- Sub caifen()
- Dim Myr&, Arr, x&
- Dim d, d1, d2, i&, j&
- Set d = CreateObject("Scripting.Dictionary")
- Set d1 = CreateObject("Scripting.Dictionary")
- Set d2 = CreateObject("Scripting.Dictionary")
- Myr = [a65536].End(xlUp).Row
- Arr = Range("a2:a" & Myr)
- Range("c2:e" & Myr).ClearContents
- my = Array("MOTO", "诺基亚", "三星", "索爱")
- gc = Array("OPPO", "联想", "天语", "金立", "步步高", "波导", "TCL", "酷派")
- For x = 1 To UBound(Arr)
- For i = 0 To UBound(my)
- If InStr(Arr(x, 1), my(i)) > 0 Then
- d(Arr(x, 1)) = ""
- GoTo 100
- End If
- Next i
- For j = 0 To UBound(gc)
- If InStr(Arr(x, 1), gc(j)) > 0 Then
- d1(Arr(x, 1)) = ""
- GoTo 100
- End If
- Next j
- d2(Arr(x, 1)) = ""
- 100:
- Next x
- Range("c2").Resize(UBound(d.Keys) + 1, 1) = Application.Transpose(d.Keys)
- Range("d2").Resize(UBound(d1.Keys) + 1, 1) = Application.Transpose(d1.Keys)
- Range("e2").Resize(UBound(d2.Keys) + 1, 1) = Application.Transpose(d2.Keys)
- End Sub
复制代码 |
|