Forum Discussion
Value Error
You say it is "breaking this" but don't say how. This should work, maybe try again?
=WRAPROWS( SEQUENCE( ,C3,0),C2, "x")
alternatively you can do a replacement using IF:
=LET( orig, SEQUENCE( ROUNDUP( C3/C2,0), C2, 0, 1), IF( orig<=C3, orig, "x")
Thanks m_tarler seems this doesn't work, I don't want to break this Sequence formula as it's correct for calculation for the no. of rows and col, for me. but on top of this can we add some formula to omit the SSBs which are >=max no of SSBs, so in below as Total no of SSB ==6( index starts from 0 , so in 2 rows it should be
0 1 2 3
4 5 x x, or we can replace "x" with "", Wraprows is breaking this..
You say it is "breaking this" but don't say how. This should work, maybe try again?
=WRAPROWS( SEQUENCE( ,C3,0),C2, "x")
alternatively you can do a replacement using IF:
=LET( orig, SEQUENCE( ROUNDUP( C3/C2,0), C2, 0, 1), IF( orig<=C3, orig, "x")