|
Sub 排序()
Dim ar As Variant
Dim i As Long, r As Long
Dim d As Object
Set d = CreateObject("scripting.dictionary")
With ActiveSheet
r = .Cells(Rows.Count, 2).End(xlUp).Row
ar = .Range("b5:c" & r)
For i = 2 To UBound(ar)
For s = i + 1 To UBound(ar)
If ar(i, 2) < ar(s, 2) Then
For j = 1 To UBound(ar, 2)
k = ar(i, j)
ar(i, j) = ar(s, j)
ar(s, j) = k
Next j
End If
Next s
zd = ar(i, 2)
If zd > 0 Then
If d(zd) = "" Then
d(zd) = ar(i, 1)
Else
d(zd) = d(zd) & "," & ar(i, 1)
End If
End If
Next i
zd = ""
For Each k In d.keys
wf = d(k)
If InStr(wf, ",") = 0 Then
If zd = "" Then
zd = d(k) & k
Else
zd = zd & "," & d(k) & k
End If
Else
zf = ""
rr = Split(wf, ",")
For s = 0 To UBound(rr)
If zf = "" Then
zf = rr(s)
Else
zf = zf & "," & rr(s)
End If
Next s
zf = zf & "各" & k
If zd = "" Then
zd = zf
Else
zd = zd & "," & zf
End If
End If
Next k
.[j6] = zd
MsgBox zd
End With
End Sub
|
评分
-
1
查看全部评分
-
|