|
- Sub COUNTIF()
- Dim arr, brr(), i&, j&, d As Object
- Set d = CreateObject("scripting.dictionary")
- arr = [i8].CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- For j = 1 To UBound(arr, 2)
- For i = 2 To UBound(arr)
- d(arr(i, j)) = d(arr(i, j)) + 1
- Next
- For i = 2 To UBound(arr)
- brr(i - 1, j) = d(arr(i, j))
- Next
- d.RemoveAll
- Next
- [bc9:bv9999] = ""
- [bc9].Resize(UBound(arr), UBound(arr, 2)) = brr
- End Sub
复制代码
请教:数据统计出现的个数.rar
(97.54 KB, 下载次数: 2)
|
|