|
- Sub tt()
- arr = [a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- n = 1
- For i = 2 To UBound(arr)
- For j = 3 To UBound(arr, 2)
- If Len(arr(i, j)) >= 7 Then
- If Not d.exists(arr(i, j)) Then
- d(arr(i, j)) = ""
- Else
- x = x & "," & i '重复的行
- Exit For
- End If
- End If
- Next
- Next
- x = x & ","
- For i = 2 To UBound(arr)
- If InStr(x, "," & i & ",") = 0 Then
- n = n + 1
- For j = 1 To UBound(arr, 2)
- arr(n, j) = arr(i, j)
- Next
- End If
- Next
- [h1].Resize(n, UBound(arr, 2)) = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|