|
统计a1-q10000区域中出现14-16次的值并在S列中显示Sub sql() Dim d, k, t, arr, cel, r@, arr1()Set d = CreateObject("Scripting.Dictionary")arr = [a1:q10000]For Each cel In arr If cel <> "" Then d(cel) = d(cel) + 1 End IfNextk = d.Keyst = d.itemsReDim arr1(1 To UBound(k) + 1, 1 To 1)For i = 0 To UBound(k) If t(i) >= 14 and t(i) <= 16 Then r = r + 1 arr1(r, 1) = k(i) End IfNext[s1].Resize(r) = arr1End Sub
报错 13 求解或更好的代码
见附件
筛选出现17次的VBA.zip
(455.61 KB, 下载次数: 3)
|
|