Description:
Get values from row/column/cell a to row/column/cell b to create a sequence.
Syntax:
[a:b]
Note:
The function creates a sequence by getting values from row/column/cell a to row/column/cell b.
If a and b are in the same row or column, get values from cell a to cell b to create a sequence;
If a and b are neither in the same row nor in the same column, get values from a rectangular area whose diagonal is the line connecting cell a and cell b to create a sequence.
The function can also be written as [a,b], which means getting values of cell a and cell b to creat a sequence; allow multiple parameters, like [a:b,c,d:e].
Parameter:
|
a |
Cell name |
|
b |
Cell name |
Return value:
A sequence
Example:
|
|
A |
B |
C |
|
|
1 |
1 |
2 |
3 |
|
|
2 |
a |
b |
c |
|
|
3 |
% |
& |
* |
|
|
4 |
=[A1:C1] |
|
|
[1,2,3] |
|
5 |
=[A1:A3] |
|
|
[1,a,%] |
|
6 |
=[A1:C3] |
|
|
[1,2,3,a,b,c,%,&,*] |
|
7 |
=[A1:C1,A2,C2:C3] |
|
|
[1,2,3,a,c,*] |