[a:b]

Read(191) Label: sequence, cell, value,

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, get values from cell a to cell b to create a sequence;

If a and b are in the same column, get values from cell a to cell b in this column 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].

Parameters:

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,*]