FILTER

Filters a data range or array based on conditions you specify.

Sintassi

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.

Return if empty: the value to return if all values in the Include array are empty (filter return nothing).

Esempio

Come esempio verranno utilizzati i dati seguenti

A

B

C

1

Matematica

Fisica

Biologia

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 {57,49,12|56,33,60|57,,} containing all grades with Maths grade above 50. Note that this is an array formula.

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

Informazioni tecniche

tip

This function is available since LibreOfficeDev 24.8.


Questa funzione non fa parte dello standard Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format. Lo spazio dei nomi รจ

COM.MICROSOFT.FILTER