Description
Computes the Lambda function on each row of a specific 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!=BYROW(array, LAMBDA)
EXAMPLE
Copied!//𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘭𝘢𝘳𝘨𝘦𝘴𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘊1, 𝘈2:𝘊2 =BYROW(A1:C2, MAX) //𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘵𝘩𝘦 𝘭𝘢𝘳𝘨𝘦𝘴𝘵 𝘷𝘢𝘭𝘶𝘦𝘴 𝘧𝘳𝘰𝘮 𝘈1:𝘊1, 𝘈2:𝘊2 =BYROW(A1:C2, LAMBDA(row, MAX(row))) //𝘳𝘦𝘵𝘶𝘳𝘯𝘴 𝘧𝘰𝘳𝘮𝘶𝘭𝘢𝘴 𝘢𝘴 𝘵𝘦𝘹𝘵 𝘴𝘵𝘳𝘪𝘯𝘨𝘴 𝘧𝘳𝘰𝘮 𝘈1, 𝘈2 =BYROW(A1:A2, FORMULATEXT) //𝘤𝘢𝘭𝘤𝘶𝘭𝘢𝘵𝘦 𝘵𝘩𝘦 𝘢𝘷𝘦𝘳𝘢𝘨𝘦 𝘧𝘰𝘳 𝘦𝘢𝘤𝘩 𝘳𝘰𝘸 𝘪𝘯 𝘴𝘦𝘲𝘶𝘦𝘯𝘤𝘦 =BYROW(SEQUENCE(2, 5), AVERAGE)