CHOOSECOLS

Retorna les columnes especificades a partir d'una matriu.

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

Sintaxi

=CHOOSECOLS(Array; Column_1 [; Column_2 [; Column_3 [; ...]]])

Array: The array containing the columns to be returned in a new array.

Column_1: The index of the first column to be returned. A negative value chooses from the end of the array.

Column_2; Column_3; ...: (optional) The list of other column indexes to be returned. A negative value chooses from the end of the array.

Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present.

Exemples

Considereu la matriu A1:E3 més avall:

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

The formula {=CHOOSECOLS(A1:E3;2;4;5)} returns the array below with columns 2,4 and 5 chosen.

BBB	DDD	EEE
	III	JJJ
LLL	NNN	OOO

The formula =CHOOSECOLS(A1:E3;1;-1) returns the array below with column 1 and column 5 chosen, note that column 5 is chosen from the end of the array.

AAA	EEE
FFF	JJJ
KKK	OOO

Use the function CHOOSECOLS to reorder the columns of an array. You can also replicate columns by repeating the column index.

Informació tècnica

Aquesta funció és disponible des de la versió 25.8 del LibreOffice.

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.CHOOSECOLS

CHOOSECOLS wiki page.