Forum Discussion
jglennbiomerics
Jul 13, 2021Copper Contributor
how to repeat a number in excel
what is the formula to have excel repeat and count after a number has been repeated four times, such as: 70 70 70 70 71 71 71 71 72 72 72 72 73 73 73 ...
- Jul 13, 2021
This is the sort of thing you appear to show.
It is Excel 365 but that is because I will never develop a workbook using and earlier version again.
Riny_van_Eekelen
Jul 13, 2021Platinum Contributor
jglennbiomerics How does the number sequence in your question (i.e. 70 to 74 in groups of 4) relate the file you uploaded?
- jglennbiomericsJul 13, 2021Copper ContributorI should have started at 70, ignore the preceding information. I will then combine the columns of data