FILTER(array ,include [,if_empty])
Returns the array of data in a range that satisfies multiple conditions.
|array||The array, or range to filter.|
|include||A Boolean array whose height or width is the same as the array.|
|if_empty||The value to return if all values in the included array are empty (filter returns nothing).|
|* This function is only available in Office 365.|
* For the Microsoft documentation refer to support.office.com
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top