|
主要是不好意思拿出手,各位老师,不喜请不要扔砖哈- Option Explicit
- Sub 开整()
- Dim DicNb As Object: Set DicNb = CreateObject("scripting.dictionary")
- Dim Arr, i, j, Brr(), n
- With Sheets("Sheet1")
- Arr = .[a1].CurrentRegion
- For i = 2 To UBound(Arr)
- If DicNb.exists(Arr(i, 2)) Then
- If Arr(i, 5) < DicNb(Arr(i, 2)) Then DicNb(Arr(i, 2)) = Arr(i, 5)
- Else
- DicNb(Arr(i, 2)) = Arr(i, 5)
- End If
- Next
- End With
- ReDim Brr(1 To 1000, 1 To 28)
- For i = 2 To UBound(Arr)
- If DicNb(Arr(i, 2)) = Arr(i, 5) Then
- n = n + 1
- For j = 1 To 28
- Brr(n, j) = Arr(i, j)
- Next
- End If
- Next
- With Sheets("sheet3")
- .Range("a2:ab" & .[a1048576].End(3).Row + 1).Clear
- .[a2].Resize(UBound(Brr), 28) = Brr
- End With
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|