排序要按00次到最多次顺序排列

[此贴子已经被作者于2018-8-2 21:52编辑过]

刚上路的新手，谢谢大侠们帮忙！！！把这个问题解决了。

这个写法明快简要我喜欢，谢谢版主！！！
Const 最大人次 = 6       '这个值不是固定值。这有时大有时小不固定。
那再加一个判断取最大值怎么写，请版主帮忙一下，谢谢！！!

得到众版主的支持，非常感谢，谢谢！！！

请教大师      n(k) = n(k) & m(i) & ","    这里下标越界问题
Private Sub Command1_Click()
Dim i As Integer, j As Integer, k As Integer, m() As String, n() As String, s As String, t As String
    s = "赵,钱,孙,陈"        '统计过程中，受限于这个值，如这里是4个姓，统计重复“孙,孙,孙,”就出错，
                             ‘假如 s = "赵,钱,孙,陈,黄"  这里是5个姓，统计重复“孙,孙,孙,”没问题，
    t = Text1.Text & ","
    m = Split(s, ",")
    ReDim n(UBound(m))
    For i = 0 To UBound(m)
      j = 1
      k = 0
      While InStr(j, t, m(i) & ",")
        k = k + 1
        j = InStr(j, t, m(i) & ",") + 1
      Wend
      n(k) = n(k) & m(i) & ","
    Next
    Text2 = ""
    For i = 0 To UBound(n)
      If n(i) <> "" Then
        Text2 = Text2 & "【共" & i & "人次】：" & n(i) & "(" & Len(n(i)) / 2 & "个姓)" & vbCrLf
      End If
    Next
End Sub

Private Sub Form_Load()
Text1.Text = "孙,孙,孙,孙"
End Sub

谢谢大师！！！