|
求高手修改
- Sub 按钮1_Click()
- Dim arr, brr, i&, j&, dic As Object
- Set dic = VBA.CreateObject("scripting.dictionary")
- arr = Range("C4:C" & Cells(Rows.Count, "C").End(3).Row)
- ar = Range("I4:I" & Cells(Rows.Count, "C").End(3).Row)
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If dic.exists(arr(i, 1)) Then
- If ar(i, 1) < dic(arr(i, 1)) Then dic(arr(i, 1)) = ar(i, 1)
- Else
- dic(arr(i, 1)) = ar(i, 1)
- End If
- Next
- For i = 1 To UBound(arr)
- If ar(i, 1) = dic(arr(i, 1)) Then
- brr(i, 1) = 1
- dic(arr(i, 1)) = -1
- Else
- brr(i, 1) = "重复"
- brr(i, 2) = 1
- End If
- Next
- Range("Q4:R" & Rows.Count).Clear
- Range("Q4").Resize(UBound(arr), 2) = brr
- End Sub
复制代码
|
|