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 |
| 73 |
| 74 |
| 74 |
| 74 |
| 74 |
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.
4 Replies
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.
PeterBartholomew1 yes, thank you!!
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
