diff options
| -rw-r--r-- | source/text/scalc/01/func_filter.xhp | 12 |
1 files 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 @@ <body> <bookmark id="bm_id221708806478124" branch="hid/SC_HID_FUNC_FILTER_MS" localize="false"/> <bookmark branch="index" id="bm_id361708283183878"> - <bookmark_value>FILTER function</bookmark_value> +<bookmark_value>FILTER function</bookmark_value> </bookmark> <section id="filter"> <h1 id="hd_id901708806478126"><variable id="h1"><link href="text/scalc/01/func_filter.xhp">FILTER</link></variable></h1> - <paragraph id="par_id771708806478128" role="paragraph">(...)</paragraph> + <paragraph id="par_id771708806478128" role="paragraph">Filters a data range or array based on conditions you specify.</paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph role="code" id="par_id211708281649651">FILTER(...)</paragraph> +<paragraph role="code" id="par_id211708281649651">FILTER(Range, Criteria, Return if empty)</paragraph> +<paragraph role="paragraph" id="par_id411709395137111"><emph>Range</emph>: The array or range to filter.</paragraph> +<paragraph role="paragraph" id="par_id471709395141324"><emph>Criteria</emph>: 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 <emph>Range</emph>.</paragraph> +<paragraph role="paragraph" id="par_id421709395146863"><emph>Return if empty</emph>: the value to return if all values in the Include array are empty (filter return nothing).</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<paragraph role="paragraph" id="par_id21709506838932"><input>{=FILTER(A2:C13,A2:A13>50)}</input> 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.</paragraph> +<paragraph role="paragraph" id="par_id561709507935610"><input>{=FILTER(A2:C13,B2:B13>90,"No results")}</input> Returns the string "No results", since no grade on Physics is above 90.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#24.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> |