LibreOfficeDev 24.8 Súgó
Filters a data range or array based on conditions you specify.
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.
COM.MICROSOFT.FILTER