- Sub aaa()
- Dim arr, brr, r1&, r2&, c1&, c2
- arr = Range("e6:i" & [i65536].End(3).Row)
- ReDim brr(1 To UBound(arr) * 2, 1 To 7)
- r1 = 1: r2 = 1: c2 = 2
- For i = 1 To UBound(arr)
- If InStr(arr(i, 5), "a") Then
- c1 = c1 + 1
- If c1 = 3 Then
- c1 = 1
- r1 = r1 + 4
- End If
- brr(r1, c1) = arr(i, 3)
- brr(r1, 5) = brr(r1, 5) + arr(i, 3)
- brr(r1, 7) = brr(r1, 7) + arr(i, 3)
- End If
- If InStr(arr(i, 5), "b") Then
- c2 = c2 + 1
- If c2 = 5 Then
- c2 = 3
- r2 = r2 + 4
- End If
- brr(r2, c2) = arr(i, 3)
- brr(r2, 6) = brr(r2, 6) + arr(i, 3)
- brr(r2, 7) = brr(r2, 7) + arr(i, 3)
- End If
- Next i
- [k6].Resize(IIf(r1 > r2, r1, r2), 7) = brr
- End Sub
复制代码 |