|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub 统计()
Dim A, D As Object, i&
Set D = CreateObject("scripting.dictionary")
A = Range("A2").Resize(Range("a" & Rows.Count).End(xlUp).Row - 1, 1)
For i = 2 To UBound(A)
If Not D.exists(A(i, 1)) Then
D.Add A(i, 1), 1
Else
D(A(i, 1)) = D(A(i, 1)) + 1
End If
Next
'假如把结果放到sheet2表的第一列和第二列
With Sheets("SHeet2")
.Activate
.Cells.Clear
.[a1].Resize(D.Count, 1) = WorksheetFunction.Transpose(D.keys)
.[b1].Resize(D.Count, 1) = WorksheetFunction.Transpose(D.items)
End With
End Sub |
|