Forum Discussion
Can result of function BYROW be a range/ sequence?
A B C D 1 5 '=SEQUENCE(10,1,A1,1) '=SEQUENCE(10,1,A2,1) '=BYROW(B1:C10,LAMBDA(x,SUM(x))) 2 10 Suppose we have a range. Each range yields a ...
This was my approach to the problem too.
The only problem is, I need HSTACK(B2#, C2#) to be replaced by a generic formula (another BYROW maybe), which will generate sequences for each element in A2:A3. We pick one element from A2:A3, generate sequence, HSTACK it, and finally SUM them all.
In this case we have just two elements, what if we need to do this for 100 elements (A2:A101)?
The only problem is, I need HSTACK(B2#, C2#) to be replaced by a generic formula (another BYROW maybe), which will generate sequences for each element in A2:A3. We pick one element from A2:A3, generate sequence, HSTACK it, and finally SUM them all.
In this case we have just two elements, what if we need to do this for 100 elements (A2:A101)?
