Incrementing by 3

[costi_tcc]

I'm not sure if I can explain properly what i need lol, but I want to create an incrementing sequence number, and after is reaching 3 to start again, and each number to be repeated one time. Please see below and thank you
1
1
2
2
3
3
1
1
2
2
3
3
1
1
.
.

 

[Joe4]

Welcome to the Board!

Where does your list start (that is, what is the address of the first cell the first "1" is going into)?

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff New.xlsm
	A
1	1
2	1
3	2
4	2
5	3
6	3
7	1
8	1
9	2
10	2
11	3
12	3
13	1
14	1
15	2
16	2
17	3
18	3
Master

Cell Formulas
Range	Formula
A1:A18	A1	=MOD(INT((ROW()-1)/2),3)+1

 

[costi_tcc]

To be more precise the column E i would like to populate automatically.

=MOD(INT((ROW()-1)/2),3)+1

 

[Joe4]

That example looks a bit different than what you posted in your original sample.

In the original sample, you have:
- Each number repeating 2 times
- The numbers resetting to 1 after hitting 3

In this new screen print, you have:
- Each number repeating 5 times
- The number resetting to 1 after hitting 4

So there some discrepancies there.
Which one is the one you really want?

 

[costi_tcc]

Sorry for the confusion, the second one, i posted the first one because it is shorter and i thought i could figure myself how to change it to adapt to my case, which is the second one with the capture screen.

 

[Fluff]

Should it always reset after 4, or one less than the value in E1?

 

[costi_tcc]

Should it always reset after 4, or one less than the value in E1?

I have in total 2000 pieces (cells) column A, each ones have an unique number 1 to 2000.
I want to to group them by bundle, and trays.
Each bundle contains 20 A cells i did that in column B, please see below the formula i use.
Now each bundle has 4 trays, and in each tray i'm trying to fit 5 records (Cells from A column).
Ignore Tray A and B (C, D) are just attempts of mine.
Down the road the numbers of bundles and trays could change, that's why i created variable cells B1 and E1, where i could change the values based on the requirements and the all columns could change automatically.

Thank you

 

[Fluff]

How about
=MOD(INT((ROWS(E$4:E4)-1)/$E$1),$E$1-1)+1

 

[costi_tcc]

How about
=MOD(INT((ROWS(E$4:E4)-1)/$E$1),$E$1-1)+1

Exactly what i need, thank you so much