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?

 

[Boston Brandon]

Maybe

Fluff.xlsm
	A	B	C
1		Start num	1
2	1	Num of pages	6
3	7	Rows/page	16
4	13	Columns/Page	14
5	19	End num	1200
6	25
7	31
8	37
9	43
10	49
11	55
12	61
13	67
14	73
15	79
16	85
17	91
18	97
19	103
20	109
21	115
22	121
23	127
24	133
25	139
26	145
27	151
28	157
29	163
30	169
31	175
32	181
33	187
34	193
35	199
36	205
37	211
38	217
39	223
40	229
41	235
42	241
43	247
44	253
45	259
46	265
47	271
48	277
49	283
50	289
Sheet5

Cell Formulas
Range	Formula
A2:A1201	A2	=TOCOL(DROP(REDUCE("",SEQUENCE(C2,,C1),LAMBDA(x,y,LET(s,SEQUENCE(C3,C4,y,C2),VSTACK(x,IF(s>C5,1/0,s))))),1),2)
Dynamic array formulas.

That seems like it would work but for some reason, the value "2" is 203 cells down instead of 225 which would be the first cell in the second page. Which also means the rest of the values are wrong.

 

[Boston Brandon]

Are your strip lengths always 14? If not, how do you determine the strip lengths?

Yes... always 14 columns by 16 rows. The example you gave me yesterday worked, I just need to be able to change the start and stop values which will effect the amount of cells and possible pages if there is only enough range to fill up 5 pages instead of 6.

 

[Cubist]

Yes... always 14 columns by 16 rows. The example you gave me yesterday worked, I just need to be able to change the start and stop values which will effect the amount of cells and possible pages if there is only enough range to fill up 5 pages instead of 6.

It worked for 1344 because 1344 is a multiple of 14, but 1200 isn't. So some of your strips will be shorter. Can you show the expected outcome when the number isn't a multiple of 14?

 

[Fluff]

the value "2" is 203 cells down instead of 225 which would be the first cell in the second page

So what do you want in those cells, should they be just blank?

 

[Boston Brandon]

It worked for 1344 because 1344 is a multiple of 14, but 1200 isn't. So some of your strips will be shorter. Can you show the expected outcome when the number isn't a multiple of 14?

I understand that. There isn't away to get the out come I want because of that math so I believe what I have will work and production will have to disregard the extra labels from 1201 to 1344. Not really a big deal as we are using the same amount of material anyway. Thank you very much for your help.

 

[Boston Brandon]

So what do you want in those cells, should they be just blank?

I can have them blank, but it will produce a label without a number so I will just keep it the way it is. Production will have to disregard the extra labels from 1201 to 1344. Not really a big deal as we are using the same amount of material anyway. Thank you very much for your help and I am sorry for the confusion earlier. You have been awesome.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Cubist]

One last comment. To figure out the minimum number of pages needed it's

=ROUNDUP(EndingNum/16/14,0)

 

[Boston Brandon]

See if this works for you.

=DROP(REDUCE("",SEQUENCE(6),LAMBDA(a,b,VSTACK(a,SEQUENCE(16,14,b,6)))),1)

Red- Number of pages
Blue - Number of rows on each page
Purple- Number of columns on each page
Orange - Increase Increment

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

Cell Formulas
Range	Formula
A1:N96	A1	=DROP(REDUCE("",SEQUENCE(6),LAMBDA(a,b,VSTACK(a,SEQUENCE(16,14,b,6)))),1)
P1:P1344	P1	=TOCOL(A1#)
Dynamic array formulas.

OK... so this is the formula that worked with a starting number of "1". Where do I change that number? The place I thought it was, is not correct.

 

[Cubist]

OK... so this is the formula that worked with a starting number of "1". Where do I change that number? The place I thought it was, is not correct.

The first SEQUENCE.

The page # formula would change slightly.

=ROUNDUP(((EndingNum-Start)+1)/16/14,0)