SOLVED

how to repeat a number in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2543585%22%20slang%3D%22en-US%22%3Ehow%20to%20repeat%20a%20number%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543585%22%20slang%3D%22en-US%22%3E%3CP%3Ewhat%20is%20the%20formula%20to%20have%20excel%20repeat%20and%20count%20after%20a%20number%20has%20been%20repeated%20four%20times%2C%20such%20as%3A%3C%2FP%3E%3CTABLE%20width%3D%2252%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2252%22%3E70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E71%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E71%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E71%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E71%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E72%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E73%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E74%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E74%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E74%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E74%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2543585%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2543795%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20repeat%20a%20number%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543795%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102454%22%20target%3D%22_blank%22%3E%40jglennbiomerics%3C%2FA%3E%26nbsp%3BHow%20does%20the%20number%20sequence%20in%20you%20question%20(i.e.%2070%20to%2074%20in%20groups%20of%204)%20relate%20the%20file%20you%20uploaded%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2543924%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20repeat%20a%20number%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2543924%22%20slang%3D%22en-US%22%3EI%20should%20have%20started%20at%2070%2C%20ignore%20the%20preceding%20information.%20I%20will%20then%20combine%20the%20columns%20of%20data%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New 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!!