diff options
Diffstat (limited to 'source/text/scalc/01/func_filter.xhp')
| -rw-r--r-- | source/text/scalc/01/func_filter.xhp | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_filter.xhp b/source/text/scalc/01/func_filter.xhp index b1e1d53a34..35a6622ab4 100644 --- a/source/text/scalc/01/func_filter.xhp +++ b/source/text/scalc/01/func_filter.xhp @@ -29,7 +29,6 @@ <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> |