|
本帖最后由 f1red88 于 2014-5-20 18:38 编辑
怎么统计该数组的相同元素的个数
Sub c1()
Dim x, y As Integer
For x = 0 To 4
For y = 0 To 9
m(x, y) = Int(Rnd() * 10)
Next
Next
sub
实现在循环中做统计,不是得出结果再统计
我猜是这个意思。 - Sub c1()
- Dim x, y As Integer
- Dim m(0 To 4, 0 To 9) As Integer
- Set d = CreateObject("scripting.dictionary")
- For x = 0 To 4
- For y = 0 To 9
- m(x, y) = Int(Rnd() * 10)
- d(m(x, y)) = d(m(x, y)) + 1
- Next
- Next
- ActiveSheet.UsedRange.ClearContents
- [a1].Resize(5, 10) = m
- [a7].Resize(1, 2) = Array("相同元素", "出现次数")
- [a8].Resize(d.Count, 1) = Application.Transpose(d.keys)
- [b8].Resize(d.Count, 1) = Application.Transpose(d.items)
- End Sub
复制代码
|
|