Forum Discussion
Weird Results from Array Manipulation - Any ideas on why?
Hi all - doing some exploring with lets and lambda in excel and passing arrays around. I found a weird quirk where something that should work doesn't work as expected in a surprising way. This prob...
BYCOL. Not sure what you'd like to receive. In general we have array of arrays which is not supported in Excel natively. There are different workarounds, for example
=LET(
many, LAMBDA(choice,
CHOOSE(
choice + 1,
10,
"b",
"harry",
"c",
SEQUENCE(4, 1, 5),
SEQUENCE(3),
45,
"d",
"lots",
"e",
"ten"
)
),
many_in_a_row, REDUCE(
"",
SEQUENCE(1, many(0)),
LAMBDA(a,v, HSTACK(a, many(v)))),
IFNA(DROP(many_in_a_row, , 1), "")
)which returns
From here you may take by INDEX desired value.