sort
1. Syntax:
Return Range
sort(Range source)
Description:
Sorts source according to the first column in the range and
places the sorted range at the current cell.
2. Syntax:
Return Range
sort(Range source,
Column pivot)
Description:
Sorts source according to the pivot
column in the range and places the sorted range at the current cell.
3. Syntax:
Return Range
sort(Range source,
Column pivot, Identifier mode)
Description:
Sorts source in reverse according to the
pivot column in the range and places the sorted range at the
current cell.
Options:
Identifier mode:
4. Syntax:
Return Range
sort(Range source,
Identifier mode)
Description:
Sorts source in reverse according to the first
column in the range and places the sorted range at the current cell.
Options:
Identifier mode:
Examples:
($a1) = sort($b1:$c7)
Before:
| orange | 4 |
| apple | |
| 5 | 32 |
| banana | -7.2 |
| mango | 18 |
| 13 | 41 |
| pear | |
After:
13 | 41 | 4 |
5 | 32 | |
apple | | 32 |
banana | -7.2 | -7.2 |
mango | 18 | 18 |
orange | 4 | 41 |
pear | | |
($b2) = sort($b1:$d10,$c,reverse)