- Sub Tj()
- Dim Arr, Brr
- Arr = [a1].CurrentRegion
- ReDim Brr(1 To 36, 0 To 9)
- For i = 0 To 9
- For j = 2 To UBound(Arr) - 1
- If CInt(Right(Arr(j, 2), 1)) = i Then
- Brr(Arr(j + 1, 2), i) = Brr(Arr(j + 1, 2), i) + 1
- End If
- Next
- Next
- [h3].Resize(36, 10).ClearContents
- [h3].Resize(36, 10) = Brr
- MsgBox "统计完成"
- End Sub
复制代码
|