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!
=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)

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