求大神用vba写一段代码
数据a sheet1 A列 数据如下
PSVO
PSVO38
SVO26
IO
ENC
IO
PSVO
要求对这列数据进行统计计数,将结果显示在数据B sheet1 A B 列
最终结果
A B
PSVO 2
PSVO38 1
SVO26 1
IO 2
ENC 1
工作簿的名字没给不好弄,现就将结果放在C、D列。
Sub demo()数据A和数据B就是工作蒲名字
追答Sub demo()
Dim d As Object, i As Long
Set d = CreateObject("scripting.dictionary")
With Workbooks("数据a.xlsm").Sheets("Sheet1")
For i = 2 To .Cells(Rows.Count, 1).End(xlUp).Row
If Not d.exists(.Cells(i, 1).Value) Then
d(.Cells(i, 1).Value) = 1
Else
d(.Cells(i, 1).Value) = d(.Cells(i, 1).Value) + 1
End If
Next
End With
With Workbooks("数据B.xlsx").Sheets("Sheet1")
.Range("A2").Resize(d.Count, 1) = Application.Transpose(Filter(d.keys, ""))
.Range("B2").Resize(d.Count, 1) = Application.Transpose(Filter(d.items, ""))
End With
End Sub
是的
追答Dim MyRows1 As Integer可以加个联系方式么,我还有一个程序需要写
什么
追答快自己好好做作业吧,不明白翻翻书!