|
发表于 2022-1-20 13:51
|
显示全部楼层
本楼为最佳答案
請測試看看,謝謝
Sub test()
Dim Arr, xD, T$, T1$, i&
Set xD = CreateObject("Scripting.Dictionary")
With Sheet1.Range("a1").CurrentRegion
Arr = .Value
For i = 2 To UBound(Arr)
T = Arr(i, 1)
If T <> "" Then
xD(T) = Array(T, Arr(i, 2)): T1 = T
Else
Arr(i, 1) = xD(T1)(0): Arr(i, 2) = xD(T1)(1)
End If
Next
.Value = Arr
.Sort Key1:=.Item(11), Order1:=1, Header:=1
End With
End Sub
|
|