Increment pattern of data down a column

[Lmreif20]

I have a code for three rows. I need to increment that code for three rows down a column. How do I do this?

AR7765

AR7765

AR7765

AR7766

AR7766

AR7766 and so on with every three rows incremented by 1

Thank you!

 

[Eric W]

Try:

Book2
	A
1
2
3	AR7765
4	AR7765
5	AR7765
6	AR7766
7	AR7766
8	AR7766
9	AR7767
10	AR7767
11	AR7767
12	AR7768
13	AR7768
14	AR7768
15	AR7769
16
17
Sheet10

Cell Formulas
Range	Formula
A4:A15	A4	=IF(COUNTIF(A$3:A3,A3)=3,LEFT(A3,2)&MID(A3,3,9)+1,A3)

Put the starting value in A3, then the formula in A4 and drag down. Or adjust the ranges to your actual location.

 

[Rick Rothstein]

I think this formula in cell A4 copied down should also work...

=LEFT(A$3,2)&MID(A$3,3,9)+INT(ROWS(A$3:A3)/3)

 

[Fluff]

Another option

+Fluff v2.xlsm
	A
1
2	AR7765
3	AR7765
4	AR7765
5	AR7766
6	AR7766
7	AR7766
8	AR7767
9	AR7767
10	AR7767
11	AR7768
12	AR7768
13	AR7768
14	AR7769
15	AR7769
16	AR7769
17	AR7770
18	AR7770
19	AR7770
20	AR7771
21	AR7771
22	AR7771
23
Main

Cell Formulas
Range	Formula
A2:A22	A2	="AR"&7765+INT(SEQUENCE(21,,0)/3)
Dynamic array formulas.