BYROW(array, lambda(row))

Returns the results from applying a LAMBDA function to each row in an array.

arrayAn array to be separated by row.
lambdaA nested LAMBDA function that takes a single parameter and calculates one result
rowA row from array.

Remarks

* Added in Microsoft 365 and is only available to Office Insiders at the moment.
* This function can return a Dynamic Array Formula.
* This function uses the LAMBDA function.
* For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows.
* This function was released in July 2021.
* You can use the BYCOL function to return the results from applying a LAMBDA function to each column in an array.
* For the Microsoft documentation refer to support.microsoft.com

 A
1??


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