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
OliverScheurichGold ContributorFeb 25, 2023dsmith177 =123455+ROW()&IF(MOD(ROW(),7)-1=-1,6,MOD(ROW(),7)-1)An alternative could be this formula.
