Number sequences

Question

Hello,Iam trying to create a numbersequence that has a last check digit that only goes from 0 up to 6 eg:123456012345711234582123459312346041234615123462612346301234641etc.any ideas?&nbsp;

fikturfox · Answer

dsmith177&nbsp;Perhaps...=LET(rowCount, 15, startNum, 123456,
SEQUENCE(rowCount,1,startNum)&amp;MOD(SEQUENCE(rowCount,1,0,1),7))The number or rows (rowCount) and starting number (startNum) are hardcoded. You can have it refer to a cell.

oliverscheurich · Answer

dsmith177&nbsp;=123455+ROW()&amp;IF(MOD(ROW(),7)-1=-1,6,MOD(ROW(),7)-1)An alternative could be this formula.&nbsp;

Forum Discussion

Number sequences

Share

Resources