Forum Discussion
Potential Bug: SEQUENCE Function Misbehaves with Dynamic start Parameter from BYROW/LAMBDA
Dear Microsoft Excel Team, I’m encountering unexpected behavior when using SEQUENCE inside a BYROW/LAMBDA construction, specifically when the start parameter of SEQUENCE is derived from the lambd...
This is what Excel sees with 'k'
=BYROW(
{4; 3},
LAMBDA(p, LET(n, 4, k, p + 0, joined, TEXTJOIN(" ", , SEQUENCE(5, , k, n)), TYPE(k)))
)
output:
64
64
Workaround:
=BYROW({4; 3}, LAMBDA(p, LET(n, 4, k, p + 0, TEXTJOIN(" ", , SEQUENCE(5, , @k, n)))))