|
- Sub test()
- Dim r&, i&, j&, c&
- Dim arr, brr, drr() As Integer
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- With Worksheets("sheet1")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- arr = .Range("a8:k" & r)
- brr = .Range("o1:s6")
- ReDim crr(1 To UBound(arr), 1 To UBound(brr, 2))
- For i = 1 To UBound(arr) Step 4
- For k = 1 To 3
- ReDim drr(1 To 33)
- For j = 1 To UBound(arr, 2)
- drr(arr(i + k - 1, j)) = drr(arr(i + k - 1, j)) + 1
- Next
- For y = 1 To UBound(brr, 2)
- frr = drr
- For x = 1 To UBound(brr)
- frr(brr(x, y)) = frr(brr(x, y)) + 1
- Next
- s = 0
- For q = 1 To UBound(frr)
- If frr(q) = 2 Then
- s = s + 1
- End If
- Next
- crr(i + k - 1, y) = s
- Next
- Next
- Next
- .Range("o8").Resize(UBound(crr), UBound(crr, 2)) = crr
- End With
- End Sub
复制代码 |
|