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 that helps :) last question on this issue, so for the SSBs(array) how to Limit the max to the Total No. of SSBs, for example,
in below the :-
Total No. of SSBs =6, then , for nbrOfSsbPerRachOccasion ==4, we should have 2 rows (roundup 6/4), but the max num of SSBs <= Total no of SSB which is 6 here, so in below 0,1,2,3,4,5 are ok and 6 and 7 should not be printed( from C6 to F7 in below case) how to achieve that.
Br,
Anupam
Maybe try this:
=WRAPROWS(SEQUENCE(,6,0),4,"")where the 6 is the toatl# and the 4 is the # of columns
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")