|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
学习一下
Sub test()
lastr = Cells(Rows.Count, "c").End(xlUp).Row
arr = Range("a1:c" & lastr)
ReDim brr(1 To UBound(arr), 1 To 3)
For i = 3 To UBound(arr)
If arr(i, 1) <> "" Then
flag = False
For k = i + 1 To UBound(arr)
If arr(k, 1) <> "" Then
If arr(i, 1) = arr(k, 1) And arr(i, 2) = arr(k, 2) And arr(i, 3) = arr(k, 3) Then
arr(k, 1) = vbNullString
flag = True
End If
End If
Next
If flag = True Then
GoTo x
End If
m = m + 1
For j = 1 To UBound(arr, 2)
brr(m, j) = arr(i, j)
Next
End If
x:
Next
[i3].Resize(m, 3) = brr
End Sub |
|