第1个回答 2012-02-17
假设数据在A1:F3,输入公式:
=TEXT(SUBSTITUTE(SUMPRODUCT((COUNTIF(A1:F3,ROW(1:9))>0)*ROW(1:9)*10^(9-ROW(1:9))),0,),REPT(" 0",SUMPRODUCT(N(COUNTIF(A1:F3,ROW(1:10)-1)>0))))
第2个回答 2012-02-17
用自定义函数最好,输入 =msort(A1:F3)
Function mSort(mrng As Range) As String
On Error Resume Next
Dim c, d, a
Set d = CreateObject("scripting.dictionary")
For Each c In mrng
d.Add c.Value, ""
Next
a = d.keys
For i = 1 To d.Count
mSort = mSort & WorksheetFunction.Small(a, i) & " "
Next i
mSort = Trim(mSort)
End Function本回答被提问者采纳
第3个回答 2012-02-17
如果数据在1列可以 ,否则增加辅助列 ,用2个函数即可实现
第4个回答 2012-02-17
使用合并单元格函数即可