FILTER

Filtra un intervalo o una matriz de datos basada en condiciones específicas.

Sintaxis

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

Ejemplo

Los datos siguientes se utilizarán como ejemplo

	A	B	C
1	Matemáticas	Física	Biología
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.

Información técnica

Esta función está disponible desde la versión 24.8 de 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.FILTER

FILTER wiki page.