How do you make a number series every 14th number?

[Boston Brandon]

I have 1100 sequential numbers that need to be in a certain order which I can't explain lol.
See image. Notice the pattern. the number "1" in cell one. The number "2" in cell 15. The number "3" in cell 29. (every 14th cell)
Number "17" in cell 2. Number "18" in cell 16, number "19" in cell 30 (every 16th number)
They will all be down column A till the number 1100. (I have them in C and E to be able to see the pattern)
Is there a fill series or table or something that would be able to do this?

 

[Fluff]

Hi & welcome to MrExcel.

What happens after the number 224 as that is the end of the sequence you have shown?

 

[ranman256]

paste in module then run

Sub FillBatch()
Dim i As Integer
Const kSKIP = 14

Range("A1").Select
For i = 1 To 1100
   ActiveCell.Value = i
   ActiveCell.Offset(kSKIP, 0).Select
Next
End Sub

 

[Fluff]

That is absolutely nothing like what the OP asked for, not to mention the use of active cell.

 

[Fluff]

This will do the 1st 224 numbers

=TOCOL(SEQUENCE(14,16),,1)

 

[KRice]

I thought something like this, although there must be an easier way. Change the two 60's in the formula to extend the list. For example, right now, the "60" series begins in row 827 and ends with a value of 268. When you say "till the number 1100", does that mean the last series begins with 1100, then 1116, 1132... or are you talking about 1100 values entirely, coverings rows 1:1100?

MrExcel_20240326.xlsx
	B
1	1
2	17
3	33
4	49
5	65
6	81
7	97
8	113
9	129
10	145
11	161
12	177
13	193
14	209
15	2
16	18
17	34
18	50
19	66
827	60
828	76
829	92
830	108
831	124
832	140
833	156
834	172
835	188
836	204
837	220
838	236
839	252
840	268
Sheet5

Cell Formulas
Range	Formula
B1:B840	B1	=TOCOL(MMULT(SEQUENCE(14,,0,16),SEQUENCE(,60,,0))+MMULT(SEQUENCE(14,,1,0),SEQUENCE(,60,,1)),,1)
Dynamic array formulas.

 

[bebo021999]

Book1
	A
1	1
2	17
3	33
4	49
5	65
6	81
7	97
8	113
9	129
10	145
11	161
12	177
13	193
14	209
15	2
16	18
17	34
18	50
19	66
20	82
21	98
22	114
23	130
24	146
25	162
26	178
27	194
28	210
29	3
30	19
31	35
32	51
33	67
34	83
35	99
36	115
37	131
38	147
39	163
40	179
41	195
42	211
43	4
44	20
45	36
46	52
47	68
48	84
49	100
50	116
51	132
52	148
53	164
54	180
55	196
56	212
57	5
58	21
59	37
60	53
61	69
62	85
63	101
64	117
65	133
66	149
67	165
68	181
69	197
70	213
71	6
72	22
73	38
74	54
75	70
76	86
77	102
78	118
79	134
80	150
81	166
82	182
83	198
84	214
Sheet1

Cell Formulas
Range	Formula
A2:A14	A2	=IF(ROW()<=14,A1+16,A1+1)
A15:A84	A15	=IF(ROW()<=14,A14+16,A1+1)

 

[Snakehips]

@Boston Brandon Maybe try the below.
Enter it in the start cell of your choice of range eg A1 for range A1:A1100
You should then get a series with 78.5 iterations of your required pattern

=LET(r,ROW(1:1100),m,MOD(r,14),q,QUOTIENT(r,14),z,IF(m=0,13,m-1),(z*16)+q+IF(z=13,0,1))

Hope that helps.

 

[Boston Brandon]

@Fluff, @KRice , @Snakehips Those will all work... and thank you. However, my request was not correct. I am going to try and explain exactly what I am doing.
I am making decals that have serial numbers on them that are sequential. There are 1100 total decals. My starting number is 114303 and ending number is 115403. I make these often and they way I do it is a fill series, saved as a .csv then data merged into InDesign. It is set up in InDesign to make 5 "pages". Each page (except for page 5) is set up to have 14 decals across and 16 decals decals down each row.
When I do the data merge, it numbers all the decals sequentially from the first one on page 1 on the top left, then continues from left to right and then down each row till the end. What I am looking to do is have the first decal be the starting number (114303) and then the one underneath that to be the second number (114304)
The image attached is exactly how I want each page set up. I used numbers 1-1100 because the actual numbers will change every month so I want to be able to do that.

serial numbers set up example.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	1	81	161	241	321	401	481	561	641	721	801	881	961	1041
2	2	82	162	242	322	402	482	562	642	722	802	882	962	1042
3	3	83	163	243	323	403	483	563	643	723	803	883	963	1043
4	4	84	164	244	324	404	484	564	644	724	804	884	964	1044
5	5	85	165	245	325	405	485	565	645	725	805	885	965	1045
6	6	86	166	246	326	406	486	566	646	726	806	886	966	1046
7	7	87	167	247	327	407	487	567	647	727	807	887	967	1047
8	8	88	168	248	328	408	488	568	648	728	808	888	968	1048
9	9	89	169	249	329	409	489	569	649	729	809	889	969	1049
10	10	90	170	250	330	410	490	570	650	730	810	890	970	1050
11	11	91	171	251	331	411	491	571	651	731	811	891	971	1051
12	12	92	172	252	332	412	492	572	652	732	812	892	972	1052
13	13	93	173	253	333	413	493	573	653	733	813	893	973	1053
14	14	94	174	254	334	414	494	574	654	734	814	894	974	1054
15	15	95	175	255	335	415	495	575	655	735	815	895	975	1055
16	16	96	176	256	336	416	496	576	656	736	816	896	976	1056
17	17	97	177	257	337	417	497	577	657	737	817	897	977	1057
18	18	98	178	258	338	418	498	578	658	738	818	898	978	1058
19	19	99	179	259	339	419	499	579	659	739	819	899	979	1059
20	20	100	180	260	340	420	500	580	660	740	820	900	980	1060
21	21	101	181	261	341	421	501	581	661	741	821	901	981	1061
22	22	102	182	262	342	422	502	582	662	742	822	902	982	1062
23	23	103	183	263	343	423	503	583	663	743	823	903	983	1063
24	24	104	184	264	344	424	504	584	664	744	824	904	984	1064
25	25	105	185	265	345	425	505	585	665	745	825	905	985	1065
26	26	106	186	266	346	426	506	586	666	746	826	906	986	1066
27	27	107	187	267	347	427	507	587	667	747	827	907	987	1067
28	28	108	188	268	348	428	508	588	668	748	828	908	988	1068
29	29	109	189	269	349	429	509	589	669	749	829	909	989	1069
30	30	110	190	270	350	430	510	590	670	750	830	910	990	1070
31	31	111	191	271	351	431	511	591	671	751	831	911	991	1071
32	32	112	192	272	352	432	512	592	672	752	832	912	992	1072
33	33	113	193	273	353	433	513	593	673	753	833	913	993	1073
34	34	114	194	274	354	434	514	594	674	754	834	914	994	1074
35	35	115	195	275	355	435	515	595	675	755	835	915	995	1075
36	36	116	196	276	356	436	516	596	676	756	836	916	996	1076
37	37	117	197	277	357	437	517	597	677	757	837	917	997	1077
38	38	118	198	278	358	438	518	598	678	758	838	918	998	1078
39	39	119	199	279	359	439	519	599	679	759	839	919	999	1079
40	40	120	200	280	360	440	520	600	680	760	840	920	1000	1080
41	41	121	201	281	361	441	521	601	681	761	841	921	1001	1081
42	42	122	202	282	362	442	522	602	682	762	842	922	1002	1082
43	43	123	203	283	363	443	523	603	683	763	843	923	1003	1083
44	44	124	204	284	364	444	524	604	684	764	844	924	1004	1084
45	45	125	205	285	365	445	525	605	685	765	845	925	1005	1085
46	46	126	206	286	366	446	526	606	686	766	846	926	1006	1086
47	47	127	207	287	367	447	527	607	687	767	847	927	1007	1087
48	48	128	208	288	368	448	528	608	688	768	848	928	1008	1088
49	49	129	209	289	369	449	529	609	689	769	849	929	1009	1089
50	50	130	210	290	370	450	530	610	690	770	850	930	1010	1090
51	51	131	211	291	371	451	531	611	691	771	851	931	1011	1091
52	52	132	212	292	372	452	532	612	692	772	852	932	1012	1092
53	53	133	213	293	373	453	533	613	693	773	853	933	1013	1093
54	54	134	214	294	374	454	534	614	694	774	854	934	1014	1094
55	55	135	215	295	375	455	535	615	695	775	855	935	1015	1095
56	56	136	216	296	376	456	536	616	696	776	856	936	1016	1096
57	57	137	217	297	377	457	537	617	697	777	857	937	1017	1097
58	58	138	218	298	378	458	538	618	698	778	858	938	1018	1098
59	59	139	219	299	379	459	539	619	699	779	859	939	1019	1099
60	60	140	220	300	380	460	540	620	700	780	860	940	1020	1100
61	61	141	221	301	381	461	541	621	701	781	861	941	1021
62	62	142	222	302	382	462	542	622	702	782	862	942	1022
63	63	143	223	303	383	463	543	623	703	783	863	943	1023
64	64	144	224	304	384	464	544	624	704	784	864	944	1024
65	65	145	225	305	385	465	545	625	705	785	865	945	1025
66	66	146	226	306	386	466	546	626	706	786	866	946	1026
67	67	147	227	307	387	467	547	627	707	787	867	947	1027
68	68	148	228	308	388	468	548	628	708	788	868	948	1028
69	69	149	229	309	389	469	549	629	709	789	869	949	1029
70	70	150	230	310	390	470	550	630	710	790	870	950	1030
71	71	151	231	311	391	471	551	631	711	791	871	951	1031
72	72	152	232	312	392	472	552	632	712	792	872	952	1032
73	73	153	233	313	393	473	553	633	713	793	873	953	1033
74	74	154	234	314	394	474	554	634	714	794	874	954	1034
75	75	155	235	315	395	475	555	635	715	795	875	955	1035
76	76	156	236	316	396	476	556	636	716	796	876	956	1036
77	77	157	237	317	397	477	557	637	717	797	877	957	1037
78	78	158	238	318	398	478	558	638	718	798	878	958	1038
79	79	159	239	319	399	479	559	639	719	799	879	959	1039
80	80	160	240	320	400	480	560	640	720	800	880	960	1040
Sheet1

 

[KRice]

Well, this will give you 14 columns across, 80 rows down, beginning at the last argument value. But do you want this table, or something broken up into pages?

=TRANSPOSE(SEQUENCE(14,80,114303))

And something like this could pos-process the result to limit the output to just 1100 entries:

=LET(start,114303,a,TRANSPOSE(SEQUENCE(14,80,start)),IF(a>start+1100,"",a))