SOLVED

how to repeat a number in excel

Copper Contributor

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
4 Replies

@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
best response confirmed by allyreckerman (Microsoft)
Solution

@jglennbiomerics 

This is the sort of thing you appear to show.

 

image.png

It is Excel 365 but that is because I will never develop a workbook using and earlier version again.

@Peter Bartholomew yes, thank you!!

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@jglennbiomerics 

This is the sort of thing you appear to show.

 

image.png

It is Excel 365 but that is because I will never develop a workbook using and earlier version again.

View solution in original post