ARRAYSORT

此函数创建一个数组,其中现有数组的项目按升序排序。

语法

=ARRAYSORT(array)

示例

单元格 D3 包含此数组:

#(1,123,789,TRUE,FALSE,"test","a","b","c","d",1)

函数 =ARRAY(D3) 返回此数组:

#(1,123,789,"a","b","c","d","test","FALSE","TRUE")