dsmith177Copper ContributorFeb 24, 2023Number sequences Hello, Iam trying to create a numbersequence that has a last check digit that only goes from 0 up to 6 eg: 1234560 1234571 1234582 1234593 1234604 1234615 1234626 1234630 1234641 etc. any...Show More
FikturFoxBrass ContributorFeb 24, 2023dsmith177 Perhaps...=LET(rowCount, 15, startNum, 123456, SEQUENCE(rowCount,1,startNum)&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.
