|
如何按统计表的格式统计计数个数,谢谢!
- Sub 计算()
- Dim A, B, i%, j%, k%
- With Sheets("数据")
- A = .Range("c2:o" & .Range("c65536").End(xlUp).Row)
- End With
- B = Sheets("统计").[a3:h8]
- For i = 1 To UBound(A)
- For j = 1 To UBound(B)
- If A(i, 1) = B(j, 1) Then
- '找列
- Select Case A(i, 13)
- Case Is < 8
- k = 2
- Case Is < 12
- k = 3
- Case Is < 18
- k = 4
- Case Is < 24
- k = 5
- Case Is < 36
- k = 6
- Case Is < 48
- k = 7
- Case Else
- k = 8
- End Select
- B(j, k) = B(j, k) + 1
- End If
- Next j
- Next i
- Sheets("统计").[a3].Resize(UBound(B), UBound(B, 2)) = B
- End Sub
复制代码
求助-分类统计2.rar
(13.06 KB, 下载次数: 59)
|
|