|
本帖最后由 jio1ye 于 2013-10-23 10:34 编辑
- Sub shachu()
- Dim arr1(), arr2, arr3(), n
- arr1 = Range("V1:V" & Range("V65535").End(xlUp).Row)
- arr2 = Range("Y2:Y" & Range("Y65535").End(xlUp).Row)
- For i = 1 To UBound(arr2)
- n = 0
- For j = 1 To UBound(arr1)
- If IsError(Application.Find(VBA.Left(arr2(i, 1), 1), arr1(j, 1))) Or IsError(Application.Find(VBA.Right(arr2(i, 1), 1), arr1(j, 1))) Then
- If VBA.Left(arr2(i, 1), 1) = VBA.Right(arr2(i, 1), 1) And Application.Count(arr1(j, 1), VBA.Right(arr2(i, 1), 1)) = 2 Then
- Else
- n = n + 1
- ReDim Preserve arr3(1 To n)
- arr3(n) = arr1(j, 1)
- End If
- Else
- End If
- Next j
- arr1 = Application.Transpose(arr3)
- Next i
- range("Z:Z")=""
- Range("z1").Resize(UBound(arr1), 1) = arr1
- End Sub
复制代码
新建 Microsoft Excel 工作表.rar
(192.98 KB, 下载次数: 14)
|
|