FILTER(array ,include [,if_empty])

Returns the array of data in a range that satisfies multiple conditions.

arrayThe array, or range to filter.
includeA Boolean array whose height or width is the same as the array.
if_emptyThe value to return if all values in the included array are empty (filter returns nothing).

Remarks

* This function is only available in Office 365.
* For the Microsoft documentation refer to support.office.com

 A
1??


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top