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?

 

[Dave Patton]

You can adapt the following to your exact requirements.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2	1	81	161	241	321	401	481	561	641	721	801	881	961	1041
3	2	82	162	242	322	402	482	562	642	722	802	882	962	1042
4	3	83	163	243	323	403	483	563	643	723	803	883	963	1043
5	4	84	164	244	324	404	484	564	644	724	804	884	964	1044
6	5	85	165	245	325	405	485	565	645	725	805	885	965	1045
7	6	86	166	246	326	406	486	566	646	726	806	886	966	1046
Sheet1

Cell Formulas
Range	Formula
A2:N81	A2	=TRANSPOSE(HSTACK(SEQUENCE(14,80,1,1)))
Dynamic array formulas.

 

[KRice]

Whoops...should have made that >=...

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

 

[Boston Brandon]

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))

I am sorry for not being able to explain this properly... but we are close.
I need it to all be in column A. My example shows what it would end up being like after the data merge from the .csv file.
So in this example below, I took row 1 and put it down a column and then row 2 underneith that in the same column. Ultimately it is just going to go down column A in the sequence in the example below.

serial numbers set up example.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	1	81	161	241	321	401	481	561	641	721	801	881	961	1041	1
2	2	82	162	242	322	402	482	562	642	722	802	882	962	1042	81
3	3	83	163	243	323	403	483	563	643	723	803	883	963	1043	161
4	4	84	164	244	324	404	484	564	644	724	804	884	964	1044	241
5	5	85	165	245	325	405	485	565	645	725	805	885	965	1045	321
6	6	86	166	246	326	406	486	566	646	726	806	886	966	1046	401
7	7	87	167	247	327	407	487	567	647	727	807	887	967	1047	481
8	8	88	168	248	328	408	488	568	648	728	808	888	968	1048	561
9	9	89	169	249	329	409	489	569	649	729	809	889	969	1049	641
10	10	90	170	250	330	410	490	570	650	730	810	890	970	1050	721
11	11	91	171	251	331	411	491	571	651	731	811	891	971	1051	801
12	12	92	172	252	332	412	492	572	652	732	812	892	972	1052	881
13	13	93	173	253	333	413	493	573	653	733	813	893	973	1053	961
14	14	94	174	254	334	414	494	574	654	734	814	894	974	1054	1041
15	15	95	175	255	335	415	495	575	655	735	815	895	975	1055	2
16	16	96	176	256	336	416	496	576	656	736	816	896	976	1056	82
17	17	97	177	257	337	417	497	577	657	737	817	897	977	1057	162
18	18	98	178	258	338	418	498	578	658	738	818	898	978	1058	242
19	19	99	179	259	339	419	499	579	659	739	819	899	979	1059	322
20	20	100	180	260	340	420	500	580	660	740	820	900	980	1060	402
21	21	101	181	261	341	421	501	581	661	741	821	901	981	1061	482
22	22	102	182	262	342	422	502	582	662	742	822	902	982	1062	562
23	23	103	183	263	343	423	503	583	663	743	823	903	983	1063	642
24	24	104	184	264	344	424	504	584	664	744	824	904	984	1064	722
25	25	105	185	265	345	425	505	585	665	745	825	905	985	1065	802
26	26	106	186	266	346	426	506	586	666	746	826	906	986	1066	882
27	27	107	187	267	347	427	507	587	667	747	827	907	987	1067	962
28	28	108	188	268	348	428	508	588	668	748	828	908	988	1068	1042
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]

Oh...then wrap the final output with TOCOL, like this?
Forget that...something isn't right

 

[Boston Brandon]

Oh...then wrap the final output with TOCOL, like this?

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

Edited to fix the TOCOL by column and keep blanks.

That code is just a fill series 1-1100 down column A.
See the pattern I am putting together below?

serial numbers set up example.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	1	81	161	241	321	401	481	561	641	721	801	881	961	1041	1
2	2	82	162	242	322	402	482	562	642	722	802	882	962	1042	81
3	3	83	163	243	323	403	483	563	643	723	803	883	963	1043	161
4	4	84	164	244	324	404	484	564	644	724	804	884	964	1044	241
5	5	85	165	245	325	405	485	565	645	725	805	885	965	1045	321
6	6	86	166	246	326	406	486	566	646	726	806	886	966	1046	401
7	7	87	167	247	327	407	487	567	647	727	807	887	967	1047	481
8	8	88	168	248	328	408	488	568	648	728	808	888	968	1048	561
9	9	89	169	249	329	409	489	569	649	729	809	889	969	1049	641
10	10	90	170	250	330	410	490	570	650	730	810	890	970	1050	721
11	11	91	171	251	331	411	491	571	651	731	811	891	971	1051	801
12	12	92	172	252	332	412	492	572	652	732	812	892	972	1052	881
13	13	93	173	253	333	413	493	573	653	733	813	893	973	1053	961
14	14	94	174	254	334	414	494	574	654	734	814	894	974	1054	1041
15	15	95	175	255	335	415	495	575	655	735	815	895	975	1055	2
16	16	96	176	256	336	416	496	576	656	736	816	896	976	1056	82
17	17	97	177	257	337	417	497	577	657	737	817	897	977	1057	162
18	18	98	178	258	338	418	498	578	658	738	818	898	978	1058	242
19	19	99	179	259	339	419	499	579	659	739	819	899	979	1059	322
20	20	100	180	260	340	420	500	580	660	740	820	900	980	1060	402
21	21	101	181	261	341	421	501	581	661	741	821	901	981	1061	482
22	22	102	182	262	342	422	502	582	662	742	822	902	982	1062	562
23	23	103	183	263	343	423	503	583	663	743	823	903	983	1063	642
24	24	104	184	264	344	424	504	584	664	744	824	904	984	1064	722
25	25	105	185	265	345	425	505	585	665	745	825	905	985	1065	802
26	26	106	186	266	346	426	506	586	666	746	826	906	986	1066	882
27	27	107	187	267	347	427	507	587	667	747	827	907	987	1067	962
28	28	108	188	268	348	428	508	588	668	748	828	908	988	1068	1042
29	29	109	189	269	349	429	509	589	669	749	829	909	989	1069	3
30	30	110	190	270	350	430	510	590	670	750	830	910	990	1070	83
31	31	111	191	271	351	431	511	591	671	751	831	911	991	1071	163
32	32	112	192	272	352	432	512	592	672	752	832	912	992	1072	243
33	33	113	193	273	353	433	513	593	673	753	833	913	993	1073	323
34	34	114	194	274	354	434	514	594	674	754	834	914	994	1074	403
35	35	115	195	275	355	435	515	595	675	755	835	915	995	1075	483
36	36	116	196	276	356	436	516	596	676	756	836	916	996	1076	563
37	37	117	197	277	357	437	517	597	677	757	837	917	997	1077	643
38	38	118	198	278	358	438	518	598	678	758	838	918	998	1078	723
39	39	119	199	279	359	439	519	599	679	759	839	919	999	1079	803
40	40	120	200	280	360	440	520	600	680	760	840	920	1000	1080	883
41	41	121	201	281	361	441	521	601	681	761	841	921	1001	1081	963
42	42	122	202	282	362	442	522	602	682	762	842	922	1002	1082	1043
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]

Scroll down to the series that begins with 61...do you want those blanks that begin to populate the last cell?

=LET(start,1,a,SEQUENCE(14,80,start),TOCOL(IF(a>=start+1100,"",a),,1))

Saw your last post...I believe you grabbed an incorrect version that I deleted.

 

[Fluff]

How about

=TOCOL(WRAPCOLS(SEQUENCE(1100,,14303),80),2)

 

[Boston Brandon]

Scroll down to the series that begins with 61...do you want those blanks that begin to populate the last cell?

=LET(start,1,a,SEQUENCE(14,80,start),TOCOL(IF(a>=start+1100,"",a),,1))

Saw your last post...I believe you grabbed an incorrect version that I deleted.

You rock! I do not want the blanks though. Looking at the formula I am not sure what represents the blank cells.

 

[Boston Brandon]

How about

=TOCOL(WRAPCOLS(SEQUENCE(1100,,14303),80),2)

That did it! Thank you very much.

 

[Fluff]

Glad we could help & thanks for the feedback.