|
- Sub myMax()
- arr = Sheet1.Range("a2:g" & Sheet1.Range("a65536").End(3).Row).Value
- Set d = CreateObject("Scripting.Dictionary")
- For i = 1 To UBound(arr)
- If d.exists(arr(i, 1)) Then
- If d(arr(i, 1)) < arr(i, 7) Then d(arr(i, 1)) = arr(i, 7)
- Else
- d(arr(i, 1)) = arr(i, 7)
- End If
- Next
- ReDim brr(1 To d.Count, 1 To 2)
- k = d.keys
- For i = 1 To UBound(k) + 1
- brr(i, 1) = k(i - 1)
- brr(i, 2) = d(k(i - 1))
- Next
- Sheet1.Range("k2:l" & d.Count + 1) = brr
- End Sub
复制代码 |
|