|
本帖最后由 laoau138 于 2017-3-1 21:26 编辑
用VBA数组 双重循环去A列重复 结果保存D列
不要用字典方法 只用数组方法
按钮控制结果输出
- Sub test()
- Dim arr, brr
- arr = Cells(1, 1).CurrentRegion
- For i = 2 To UBound(arr)
- For j = 1 To i - 1
- If arr(i, 1) = arr(j, 1) Then
- n = n + 1
- End If
- Next
- If n > 0 Then
- arr(i, 1) = "@"
- End If
- n = 0
- Next
- brr = VBA.Filter(Application.Transpose(arr), "@", False)
- [d1].Resize(UBound(brr) + 1, 1) = Application.Transpose(brr)
- End Sub
复制代码
|
|