How to get repeating numbers in excel 1,1,1,2,2,2

Multiple different methods for making repeating numbers in excel.
=IF(E2=E4,E4+1,E4)
=INT((ROW(A1)-1)/3)+1
=INT((ROW()-2)/3)+1
=INT((ROWS($G$1:G1)-1)/3)+1
=INT(SEQUENCE(15,,0,1/3))+1
=(QUOTIENT(ROW(A1)-1,3)*2)+10
=ROUNDUP(ROW(A1)/5,0)
=ROUNDDOWN((ROW(A1)-1)/3,0)+1
=CEILING.MATH(ROW(A1)/3)
=FLOOR.MATH((ROW(A1)-1)/3)+1
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, Beta Channel, Version 2104
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to autofill numbers in excel • How to autofill number...
- How to get repeating numbers in excel 1,2,3,1,2,3 • How to get repeating n...
- How to make REPEAT formula in excel using LAMBDA • How to make REPEAT for...

[@figyfigy754]

Finding a video that addresses my question exactly and doesn’t contain a ton of annoying filler is the best thing that’s happened to me all week

[@Moones95]

Thank you so much for this! Real lifesaver!

[@babasegy7545]

very simple but helpful, watched many complicated videos doing same thing

[@SHAILESH506]

Your tutorials are easy simple and to the point, while you also explained why we did this. Subscribed!

[@banerjeenandan]

I was wondering about the process. But this video made my job very very simple. Thank you very much.

[@algoparadecir440]

Thanks a lo!
Thanks Karina! You've saved me hours of work with clear explanations and to the point - simply wonderful! :)

[@dbcspineclinicgymbangkok1563]

excellend tutorial, concise, but insightful and practical

[@HelloThere-lo3qi]

Thank youu, i was so confuse and you explained it easily + the title hahaha makes it easier to seaerch

[@devanjalibasou6331]

Perfect, was looking for exactly this

[@chiragpatel4533]

Thanks you sooo much. You made my day 🎉🎉🎉..

[@patrickschardt7724]

These tutorials are always so helpful. Great work. You deserve so many more subscribers and views

[@saibabam3608]

Excellent sir thank u🙏🙏🙏🙏

[@rinkygarg9551]

Much Thanks, exactly looking for this. So helpful. 👏👏👏👏👌🏻👌🏻

[@jamalshah2210]

very well explained. Bravo

[@TheNomadGamerYTC]

Thank you i was looking for this for a friend lol

[@GOODVIBESTVPhil]

I love your tutorial madam

[@GOODVIBESTVPhil]

also madam is you dont mind me asking, what about if i limiit the numbers maximum at 2, how can make it like this. 111 222 111 222 111 222

[@ericzheng4815]

Can I ask a question, please? I want my column to be A1: DL-1 V1, A2: DL-1 V2, A3: DL-2 V1, A4: DL-2 V2, A5: DL-3 V1, A6: DL-3 V2... I've tried autofill and flash fill. Sadly they just don't recognize the pattern. What can I do about it? Thanks in advance!

[@karinaadcock]

This should do it:
="DL-"&ROUNDUP(ROW(A1)/2,0)&" V"&IF(ISEVEN(ROW(A1)),2,1)

[@VanessaQuindo]

Hello. Is there a formula like no. 1 repeating every 12th times , after repeating 12th times it increments by 1 until it reached no. 24 then goes back to no. 1? Thanks! :)

[@shamsshams9762]

Thank you so much

[@LupePena-p4h]

is there a formula that can help with a pattern going across columns such as 1111, 3333, 1111, 3333, 2222, 4444, 2222, 4444, 1111, 3333. One digit per column and then continue on the next row?

[@shaikhashraf5010]

thanks a lot mam

[@fevjim]

Thank you, you saved me!!

[@Freshxdesign]

Very nice :)

[@SRMV19]

Wow !, thanks ! really helpful

[@malkuth27]

Fantastic - thanks so much!

[@Krzemisir]

thank youuu!

[@universalbriquette3424]

how do i did the first one but with variable in front of it

[@universalbriquette3424]

for example, book1,book1,book2,book2,book3,book3

[@michaelsalim6076]

I need this but in google sheets

[@abbottkatz8830]

An alternative formula to copy, say, values 1-5 in B3:B7 10 times each: =TOCOL(B3:B7&A1:J1) where A1:J1 are empty.

[@saifunazar322]

Can I get
111
112
121
122
211and so on?

[@harsinchh4342]

1,2,1,2,1,2.....🤔