FILTER

Filters a data range or array based on specified conditions.

Sintaxia

FILTER( Range; Criteria [; Return if empty])

Range: The array or range to filter.

Criteria: A boolean array whose height (filtering by columns) or width (filtering by rows) is the same as the array, used to select data from the Range.

Result if empty: (optional) the value to return if all values in the Criteria array are empty (filter return nothing).

Adibidea

Hurrengo datuak erabiliko dira adibide gisa

1	Matematika	Fisika	Biologia
	A	B	C
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

{=FILTER(A2:C13;A2:A13>50)} returns the array containing all grades with Maths grade above 50. Note that this is an array formula.

57	49	12
56	33	60
57

{=FILTER(A2:C13;B2:B13>90;"No results")} Returns the string "No results", since no grade on Physics is above 90.

Informazio teknikoa

This function is available since LibreOffice 24.8.

Funtzio hau ez dago Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format estandarrean. Izen-espazioa honakoa da:

COM.MICROSOFT.FILTER

FILTER wiki page.

1	Matematika	Fisika	Biologia
	A	B	C
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

1	Matematika	Fisika	Biologia
	A	B	C
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

1	Matematika	Fisika	Biologia
	A	B	C
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26