|
If a single-column cell range is provided for column, to sort the corresponding rows of data, you must specify the same cell range for data. Otherwise, the default is to sort the first n rows of data. For example, to sort corresponding rows, specify: TEMP = SORT(V1[100:200], V2[100:200]:V5) Otherwise, TEMP = SORT(V1[100:200], V2:V5) is equivalent to: TEMP = SORT(V1[100:200], V2[1:101]:V5)
|
TEMP = SORT(COLUMN(5, 3, 2, 4, 1)) or TEMP = SORT(COLUMN(5, 3, 2, 4, 1), ASCEND)
|
Creates three new columns named TEMP, VX, and VY. The values in the TEMP column are the sorted contents of column V1 in ascending order. The values of the VX column are the corresponding contents of column V2, and the values of the VY column are the corresponding contents of column V3.
|
Creates a new column named TEMP, where the first 11 cells contain the sorted values of the cells in rows 10-20 of column V1, in descending order. The other cells in TEMP are empty.
|
TEMP = SORT(V1[5:10], V2) or TEMP = SORT(V1[5:10], V2[1:6])
Creates a new column named TEMP, where the first 6 cells contain the values from rows 1-6 of column V2, sorted in descending order of cells 5-10 of column V1. The other cells in TEMP are empty.
|
Creates a new column named TEMP, where the first 6 cells contain the sorted values of the cells in rows 5-10 of column V2 according to descending order of cells 5-10 of column V1. The other cells in TEMP are empty.
|
TEMP = SORT(V1[10:50], V2:V3) or TEMP = SORT(V1[10:50], V2[1:41]:V3)
Creates two new columns named TEMP and VX, each with values in rows 1-41 (the other cells are empty). The values in column TEMP are the values from rows 1-41 of column V2, sorted according to rows 10-50 of column V1. Similarly, the values in column VX are the values from rows 1-41 of column V3, sorted according to rows 10-50 of column V1. Column V1 is sorted in ascending order.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|