|
发表于 2021-11-21 18:51
|
显示全部楼层
本楼为最佳答案
本帖最后由 大灰狼1976 于 2021-11-21 19:01 编辑
如果都是0-99范围内的数字,可以用数组快速排序,如下:
Function COUNTOFDATA(Ind As Double, Optional ByVal Args As Range) As String
Dim rng As Range, arr(99) As Long, arrTmp, i&, sTmp$
For Each rng In Args
arrTmp = Split(rng.Value, ",")
For i = 0 To UBound(arrTmp)
If Len(arrTmp(i)) Then arr(arrTmp(i)) = arr(arrTmp(i)) + 1
Next i
Next rng
For i = 0 To 99
If arr(i) = Ind Then sTmp = sTmp & "," & i
Next i
If Len(sTmp) Then COUNTOFDATA = Mid(sTmp, 2) Else COUNTOFDATA = "NO DATA"
End Function
|
评分
-
查看全部评分
|