TAKE

Returns a specified number of contiguous rows or columns from the start or end of an array.

Enter the formula as an array formula. Hint: enter formula using keys Ctrl + Shift + Enter.

Syntaxe

=TAKE(Array; Rows [; Columns])

Array: the array or range from which to take rows or columns.

Rows: the number of rows to take. A negative value takes from the end of the array.

Columns: (optional) the number of columns to take. A negative value takes from the end of the array.

Jakýkoli z volitelných argumentů lze vynechat. Volitelný argument vyžaduje, aby byly přítomny všechny předchozí oddělovače.

Příklady

Consider the array A1:E3 below:

	A	B	C	D	E
1	AAA	BBB	CCC	DDD	EEE
2	FFF			III	JJJ
3	KKK	LLL	MMM	NNN	OOO

The formula {=TAKE(A1:E3;;1)} returns the array with 3 rows (default) and 3 columns.

AAA	BBB	CCC
FFF
KKK	LLL	MMM

The formula {=TAKE(A1:E3;2;4)} returns the array below with 2 rows and 4 columns.

AAA	BBB	CCC	DDD
FFF			III

The formula {=TAKE(A1:E3;-2;-2)} returns the array below taking 2 rows starting from the last row and 2 columns starting from the last column.

III	JJJ
NNN	OOO

Technické informace

Tato funkce je k dispozici od verze LibreOffice 25.8.

This function is NOT part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.TAKE