sub test()
'假设数据在A列,结果在B、C列
dim dic as object
set dic=createobject("scription.dictionary")
arr=range([A1],[A65536].end(xlup))
for i=1 to ubound(arr,1)
if arr(i,1)<>"" then dic(arr(i,1))=dic(arr(i,1))+1
next
[b1].resize(dic.count,1)=application.transpose(dic.keys)
[c1].resize(dic.count,1)=application.transpose(dic.items)
end sub
追问
追答sub test()
'假设数据在A列,结果在B、C列
dim dic as object
set dic=createobject("scripting.dictionary")'拼错了。。。
arr=range([A1],[A65536].end(xlup))
for i=1 to ubound(arr,1)
if arr(i,1)<>"" then dic(arr(i,1))=dic(arr(i,1))+1
next
[b1].resize(dic.count,1)=application.transpose(dic.keys)
[c1].resize(dic.count,1)=application.transpose(dic.items)
end sub
本回答被网友采纳