Forum Discussion
Solved
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 ...
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.
jglennbiomerics How does the number sequence in your question (i.e. 70 to 74 in groups of 4) relate the file you uploaded?
I should have started at 70, ignore the preceding information. I will then combine the columns of data