Description
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)

Join our newsletter to stay up to date

Click the button below to sign up for our advanced platform. Get started now and see the benefits for yourself.

EN | VI