FILTER

Filters a data range or array based on specified conditions.

Syntax

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

Example

The following data will be used as example

1	Maths	Physics	Biology
	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.

Technical information

Toś ta funkcija jo wót LibreOffice 24.8 k dispoziciji.

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

FILTER wiki page.

1	Maths	Physics	Biology
	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	Maths	Physics	Biology
	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	Maths	Physics	Biology
	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