MAP |
MAP(array, lambda_or_array2) |
Returns the array formed by applying a map using a LAMBDA function. |
array | The array to be mapped. |
lambda_or_array2 | The LAMBDA function must be the last argument. |
REMARKS |
* This function was added in Excel 2024. * This function can create a Dynamic Array Formula. * This function uses the LAMBDA function. * The Eta Reduced Lambda syntax cannot be used here. * The LAMBDA function must be the last argument. * The LAMBDA function must have a parameter for each array. * You can use the REDUCE function to return a single value after applying a LAMBDA function to an array. * You can use the SCAN function to return an identical array by applying a LAMBDA function to return some intermediate calculation values. * This function was first released in July 2021. * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - We would like to square all the numbers in the array that are greater than 5. 2 - We would like to square all the numbers in the array that are greater than 5. 3 - We would like to square all the numbers in the array that are greater than 5. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top