From 0fb58194a0658fe83ca170a9cb8adf72371c8c3e Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Sun, 3 Mar 2024 20:23:10 -0300 Subject: tdf#159872 Help page for FILTER function. Change-Id: Ie0cb1513500a1660688687fe8ac3e4b569b345a9 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164320 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/func_filter.xhp | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) diff --git a/source/text/scalc/01/func_filter.xhp b/source/text/scalc/01/func_filter.xhp index 7e9e7a69e8..b1e1d53a34 100644 --- a/source/text/scalc/01/func_filter.xhp +++ b/source/text/scalc/01/func_filter.xhp @@ -18,15 +18,21 @@ - FILTER function +FILTER function

FILTER

- (...) + Filters a data range or array based on conditions you specify.

-FILTER(...) +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).

+{=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.

-- cgit