MAP (array, lambda_or_array)

Returns the array formed by applying a map using a LAMBDA function.

arrayAn array to be mapped.
lambda_or_arrayA LAMBDA or 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.
* The "lambda_or_array" must be the last argument and which must have either a parameter for each array passed, or another array to be mapped.
* This function was released in July 2021.
* For the Microsoft documentation refer to support.microsoft.com

 A
1??


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