Description
Computes the Lambda function on each column of the range or an array and returns the corresponding results.
NOTE
- The returned array has the same height as the original array.
- Common error:
– The function will return a #VALUE! when you providing an invalid Lambda function.
Syntax
Copied!=BYCOL(array, LAMBDA)
EXAMPLE
Copied!//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘭𝘢𝘳𝘨𝘦𝘴𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘈2, 𝘉1:𝘉2, 𝘊1:𝘊2 =BYCOL(A1:C2, MAX) //𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘭𝘢𝘳𝘨𝘦𝘴𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘈2, 𝘉1:𝘉2, 𝘊1:𝘊2 =BYCOL(A1:C2, LAMBDA(col, MAX(col))) //𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘧𝘰𝘳𝘮𝘶𝘭𝘢𝘴 𝘢𝘴 𝘵𝘦𝘹𝘵 𝘴𝘵𝘳𝘪𝘯𝘨𝘴 𝘧𝘳𝘰𝘮 𝘈1, 𝘉1 =BYCOL(A1:B1, FORMULATEXT) //𝘤𝘢𝘭𝘤𝘶𝘭𝘢𝘵𝘦 𝘵𝘩𝘦 𝘢𝘷𝘦𝘳𝘢𝘨𝘦 𝘧𝘰𝘳 𝘦𝘢𝘤𝘩 𝘤𝘰𝘭𝘶𝘮𝘯 𝘪𝘯 𝘴𝘦𝘲𝘶𝘦𝘯𝘤𝘦 =BYCOL(SEQUENCE(2, 5), AVERAGE)