- Sub 统计()
- arr = Range("c11:h" & [c65536].End(3).Row)
- sz = [j10] '指定数字
- Dim brr(1 To 1, 1 To 33) '储存结果
- For i = 1 To UBound(arr) - 1
- For j = 1 To UBound(arr, 2)
- x = arr(i, j)
- If x = sz Then '第i行含指定数字
- For jj = 1 To UBound(arr, 2)
- p = arr(i + 1, jj) '下一行的各数
- brr(1, p) = brr(1, p) + 1 '某数出现一次,Brr对应位置+1
- Next
- Exit For
- End If
- Next
- Next
- [J12].Resize(, 33) = brr
- End Sub
复制代码 |