|
发表于 2017-5-3 23:08
|
显示全部楼层
本楼为最佳答案
本帖最后由 france723 于 2017-5-3 23:10 编辑
f2:bn20000范围内数据全满
- Sub bbb()
- Sheets("Sheet1").Select
- Dim d, br, c, k, n, m, s, j&, i&, t
- br = Range("f2:bn20000")
- Set d = CreateObject("scripting.dictionary")
- For j = 1 To UBound(br)
- For c = 2 To 61
- d(br(j, 1)) = d(br(j, 1)) & "," & br(j, c)
- Next c
- Next j
- m = 1
- For Each k In d.keys
- Sheets("Sheet2").Select
- For n = 1 To 10
- t = 0
- n = Mid(n, 1)
- Cells(n, m) = n
- s = Split(Mid(d(k), 2), ",")
- For i = 0 To UBound(s)
- If s(i) = n Then
- t = t + 1
- End If
- Next i
- Cells(n, m + 1) = t
- Next n
- m = m + 3
- Next k
- End Sub
复制代码
|
评分
-
查看全部评分
|