点击文件名下载附件
Sub aa()
Dim d As New Dictionary
Dim i As Long
Dim arr()
arr = Sheet1.Range("A2:A" & Sheet1.Range("A65536").End(xlUp).Row)
ReDim Preserve arr(1 To UBound(arr, 1), 1 To 2)
For i = 1 To UBound(arr, 1)
If d.Exists(arr(i, 1)) Then
arr(i, 2) = "其他"
Else
d(arr(i, 1)) = ""
arr(i, 2) = True
End If
Next i
Sheet1.Range("A2").Resize(UBound(arr, 1), 2) = arr
End Sub
点击文件名下载附件
Sub aa()
Dim d As New Dictionary
Dim i As Long
Dim arr()
arr = Sheet1.Range("A2:A" & Sheet1.Range("A65536").End(xlUp).Row)
ReDim Preserve arr(1 To UBound(arr, 1), 1 To 2)
For i = 1 To UBound(arr, 1)
If d.Exists(arr(i, 1)) Then
arr(i, 2) = "其他"
Else
d(arr(i, 1)) = ""
arr(i, 2) = True
End If
Next i
Sheet1.Range("A2").Resize(UBound(arr, 1), 2) = arr
End Sub