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