|
本帖最后由 france723 于 2017-3-28 20:21 编辑
如图所示, 单元格内容 I1,I10,I2,I3,I4,I9 排序混乱
想实现,单元格内容升序排序 I1,I2,I3,I4,I9,I10
如果单元格内容变化, 程序一样使用
B1=px(A1)
- Function px(x, n) 'x为要排序的字符,n为数字前字母的个数
- xrr = Split(x, ",")
- Dim arr()
- For i = 0 To UBound(xrr)
- s = Val(Mid(xrr(i), n + 1))
- If s > maxs Then
- maxs = s
- ReDim Preserve arr(s)
- End If
- arr(s) = xrr(i)
- Next
- For i = 0 To maxs
- If arr(i) <> "" Then px = px & "," & arr(i)
- Next
- px = Mid(px, 2)
- End Function
复制代码
|
|