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")
此函数创建一个数组,其中现有数组的项目按升序排序。
=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")