|
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- n = [t1] '行数
- xrr = Range("k4:o" & [k65536].End(3).Row) '源数据
- ReDim yrr(n To UBound(xrr), 1 To UBound(xrr, 2)) '显示结果
-
- For j = 1 To UBound(xrr, 2) '各列
- For k = n To UBound(xrr) '从指定行开始
- p = xrr(k, j) '特定数
- For i = k - 1 To k - n + 1 Step -1
- If xrr(i, j) = p Then d(xrr(i + 1, j)) = d(xrr(i + 1, j)) + 1
- Next
-
- If d.Count > 1 Then
- ReDim brr(1 To Application.Max(d.items))
- For kk = 0 To 9 'key从小到大
- x = d(kk)
- If x > 0 Then brr(x) = brr(x) & kk
- Next
-
- For i = UBound(brr) To 1 Step -1 '出现次数从大到小
- yrr(k, j) = yrr(k, j) & brr(i)
- Next
- d.RemoveAll
- End If
- Next
- Next
- [q123].Resize(UBound(yrr) - n + 1, UBound(yrr, 2)) = yrr
- End Sub
复制代码 |
评分
-
查看全部评分
|