BYCOL |
BYCOL(array, lambda(column)) |
Returns the results from applying a LAMBDA function to each column in an array. |
array | An array to be separated by column. |
lambda | A nested LAMBDA function that takes a single parameter. |
column | A column from array. |
REMARKS |
* This function was added in Microsoft 365. * This function can create a Dynamic Array Formula. * This function uses the LAMBDA function. * This LAMBDA function must take a single parameter. * This LAMBDA function must have parameter names that do not contain any numbers. * This LAMBDA function must have a calculation formula that is compatible with arrays. * You can use the BYROW function to return the results from applying a LAMBDA function to each row in an array. * 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 - What is the result of passing in the value "5" to the function "SUM(5,5)". 2 - What is the result of passing in the value "10" to the function "SUM(10,10)". 3 - What is the result of passing in the array values {10;20} (with semi-colons) to the function "SUM(array)". 4 - What is the result of passing in the array values {10;20;30;40} (with semi-colons) to the function "MAX(array)". 5 - What is the result of passing in the values from cell reference "B1:B3" to the functon "SUM(array)". 6 - What is the result of passing in the values from cell reference "B1:B3" to the functon "AVERAGE(array)". 7 - What is the result of passing in the array values {10,20} (with commas) to the function "SUM(array)". 8 - If the calculation formula passed to the LAMBDA function is not compatible with arrays, then #CALC! is returned. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top