FILTER(array ,include [,if_empty])

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

arrayThe array, or range to filter.
includeThe array containing boolean values to indicate the filtering criteria.
if_empty(Optional) The value to return if all values in the "include" array are empty (filter returns nothing).

Remarks

* This function is only available in Microsoft 365.
* This function can return a Dynamic Array Formula.
* If "array" and "include" are not the same size, then
* If "include" does not contain all boolean values, then
* You can use the SORT function to return an array of data that has been sorted.
* For the Microsoft documentation refer to support.office.com

 ABC
1=FILTER(B1:B4,B1:B4="two") = twoone30
2=FILTER(B1:B4,B1:B4="one") = { "one", "one" }two20
3=FILTER(B1:C4,B1:B4="one") = { "one", 30, "one" , 50 }one50
4textthree10


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