|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
参与一下。
- Sub test()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- sort_array = Array("研究生", "本科", "专科")
- For i = 0 To UBound(sort_array)
- d(sort_array(i)) = i
- Next
- arr = [a1].CurrentRegion
- For i = 2 To UBound(arr)
- If Not d1.exists(arr(i, 1)) Then
- d1(arr(i, 1)) = d(arr(i, 2))
- Else
- d1(arr(i, 1)) = Application.Min(d1(arr(i, 1)), d(arr(i, 2)))
- End If
- Next
- k = 1
- For Each x In d1.keys
- k = k + 1
- arr(k, 1) = x: arr(k, 2) = sort_array(d1(x))
- Next
- Range("D1").Resize(k, 2) = arr
- End Sub
复制代码 |
|