trying to automate my Switch list for my model railroad operations.

[Cwboysteve]

I'm needing a little help figuring out how to keep the duplicate picks from showing up on my list. I've got the list to populate kinda the way it should, but I don't want duplicates. As I have it now I'm running the "set outs" from the top 50 of the list to the right and the "pick ups" from the bottom 50 of the list to the right. I'd rather just be able to pull from the whole list but I'm stumped. Any help would be appreciated.
Thanks, Steve.

The formula is copied across from B1 to I5 and then down.

 

[Cwboysteve]

It will be later today before I can try that... work gets in the way of life sometimes

 

[Fluff]

You can upload the file to OneDrive or GoogleDrive, mark for sharing & post the link you are given to the thread.

 

[Cwboysteve]

auto switchlist.xlsx
	B
5	#SPILL!
Sheet1

Cell Formulas
Range	Formula
B5	B5	=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)

 

[Cwboysteve]

auto switchlist.xlsx
	B
5	#SPILL!
Sheet1

Cell Formulas
Range	Formula
B5	B5	=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)

Did I do this right?

 

[Fluff]

You need to select the whole range, not a single cell.
That said did you clear all the cells from B5 down & across to col I?

 

[Cwboysteve]

You need to select the whole range, not a single cell.
That said did you clear all the cells from B5 down & across to col I?

yes, I've got everything below cleared

auto switchlist.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Date:						4/5/2024
2	SET OUTS
3	6		Train:	#2541-GP50			Location:	Elk			1	2	3	4	5	6	7	8	9	10	11
4			Location	Rpt. Marks	Number	AAR Type	LD/MTY	Destination	Notes		Block	ID	Rpt. Marks	Car No.	Type	Description	Color	Length	LD/MTY	Empty Return to 1	Notes
5	1	#SPILL!									Elk	1	UP	65263	GB	Gondola	Yellow	41'	Loaded	Elk Track 2
6	2										Elk	2	SOUTHERN	1229	GB	Gondola	Silver	41'	Loaded	Elk Track 4
7	3										Spokane	3	SOUTHERN	1230	GB	Gondola	Silver	41'	Empty	Team Track
8	4										Spokane	4	CN	1231	GB	Gondola	Red	41'	Trash	Team Track
9	5										Spokane	5	North	1232	GB	Gondola	Black	48'	Trash	Team Track
10	6										Elk	6	CO	218892	GB	Gondola	Black	41'	Loaded	Elk Track 5
11	7										Elk	7	ELK	GB1230	GB	Gondola	Black	41'	Loaded	Elk Track 5
12	8										Elk	8	ELK	GB1231	GB	Gondola	Black	41'	Empty	Elk Track 5
13	9										Elk	9	ELK	GB1232	GB	Gondola	Black	41'	Empty	Elk Track 5
14	10										Elk	10	ELK	GB1233	GB	Gondola	Black	41'	Empty	Elk Track 5
15	11										Elk	11	ACF	5250	HT	4 Bay Hopper	White	60'	Loaded	Coop
16	12										Elk	12	ACF	5251	HT	4 Bay Hopper	White	60'	Loaded	Coop
17	13										Spokane	13	ATSF	301488	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
18	14										Spokane	14	ATSF	301489	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
19	15										Elk	15	PRR	262581	HT	4 Bay Hopper	Brown	40'	Empty	Elk Track 2
20	16										Spokane	16	ELK	HT1301	HT	4 Bay Hopper	Black	62'	Empty	Team Track
21	17										Spokane	17	ELK	HT1302	HT	4 Bay Hopper	Black	62'	Empty	Team Track
22	18										Spokane	18	ELK	HT1303	HT	4 Bay Hopper	Black	62'	Empty	Team Track
23	19										Elk	19	WA	32985	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
24	20										Elk	20	WA	32986	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
25	21										Elk	21	B&O	837085	LO	3 Bay Hopper	Gray	45'	Empty	Elk Track 4
26	22										Elk	22	L&N	30069	LO	3 Bay Hopper	Brown	44'	Empty	Elk Track 4
27	23										Spokane	23	BN	521476	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
28	24										Spokane	24	BN	521477	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
29	25										Spokane	25	BN	521478	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
30											Spokane	26	BN	521479	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
31	PICK UPS										Spokane	27	BN	521480	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
32			Location	Rpt. Marks	Number	AAR Type	LD/MTY	Destination	Notes		Spokane	28	BN	521481	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
33	1										Spokane	29	BN	521482	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
34	2										Spokane	30	BN	521483	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
35	3										Spokane	31	MKT	10683	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
36	4										Spokane	32	BN	163210	HT	90 Ton Hopper	Red		Loaded	Spokane Yard
37	5										Spokane	33	RG	17491	HT	90 Ton Hopper	black		Loaded	Spokane Yard
38	6										Spokane	34	BN	163210	HT	90 Ton Hopper	Alum.		Loaded	Spokane Yard
39	7										Davis	35	ELK		HM	2 Bay Hopper	Black		Empty	Lumber Mill
40	8										Davis	36	GN	176857	HM	2 Bay Hopper	Gray	20'	Empty	Lumber Mill
41	9										Davis	37	GN	176858	HM	2 Bay Hopper	White	20'	Empty	Lumber Mill
42	10										Elk	38	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
43	11										Elk	39	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
44	12										Elk	40	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
45	13										Elk	41	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
46	14										Elk	42	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
47	15										Elk	43	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
48	16										Elk	44	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
49	17										Elk	45	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
50	18										Elk	46	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
51	19										Elk	47	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
52	20										Elk	48	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
53	21										Elk	49	BN	189784	XM	Boxcar	Green	40'	Empty	Track 1 Elk Yard
54	22										Elk	50	B&O	11147	XM	Boxcar	Yellow	50'	Empty	Track 1 Elk Yard
55	23										Elk	51	LV	41003	XM	Boxcar	white	40'	Loaded	Monument Mnf
56	24										Elk	52	LV	41004	XM	Boxcar	white	40'	Loaded	Coop
57	25										Elk	53	CN	553290	XAF	BoxCar	Brown	60'	Empty	Coop
58											Elk	54	NW	47500	XM	Boxcar	Black	40'	Empty	Monument Mnf
59											Elk	55	GN	20680	XM	Boxcar	Green	40'	Loaded	"Transfer n Storage"
60											Elk	56	GN	22020	XM	Boxcar		40'	Loaded	"Transfer n Storage"
61											Elk	57	BN	3407	XM	Boxcar	Green	40'	Loaded	Oil Depot
62											Davis	58	WP	3301	XM	Boxcar	Brown	40'	Loaded	Davis
63											Davis	59	WP	61959	XM	Boxcar	Brown	40'	Empty	Davis
64											Davis	60	GN	11877	XM	Boxcar	Red	40'	Empty	Davis
65											Davis	61	VT	1015	XM	Boxcar	Brown	40'	Empty	Davis
66											Davis	62	rprx	507	RCD	Refer Boxcar	Yellow	40'	Loaded	Stock Yard
67											Davis	63	WA	3000	RCD	Refer Boxcar	Yellow	40'	Empty	Stock Yard
68											Elk	64	SF	55360	RCD	Refer Boxcar	Orange	50'	Loaded	Track 1 Elk Yard
69											Davis	65	SF	55361	RCD	Refer Boxcar	Orange	50'	Loaded	Meat Packing
70											Davis	66	LV	RCD71120	RCD	Refer Boxcar	white	50'	Empty	Meat Packing
71											Elk	67	LV	RCD71121	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
72											Davis	68	ELK	RCD71122	RCD	Refer Boxcar	white	50'	Loaded	Davis
73											Davis	69	ELK	RCD71123	RCD	Refer Boxcar	white	50'	Loaded	Davis
74											Elk	70	ELK	RCD71124	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
75											Elk	71	WSRX	238	T	Tank Car	Brown	40'	Empty	Track 1 Elk Yard
76											Elk	72	SCCX	1245	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
77											Elk	73	GN	1153	T	Tank Car	Black	40'	Empty	Track 1 Elk Yard
78											Elk	74	SCCX	1246	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
79											Elk	75	SP	97732	TA	Chemical Tank Car	Silver	40'	Empty	Track 1 Elk Yard
80											Elk	76	UC	97778	TA	Chemical Tank Car	white	40'	Loaded	Track 2 Elk Yard
81											Elk	77	ATSF	582039	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
82											Elk	78	ELK	SM52148	SM	Stock Car (Cattle)	Brown	40'	Empty	Ranch
83											Elk	79	D&RGW	62135	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
84											Elk	80	ATSF	50659	SM	Stock Car (Cattle)	Green	40'	Loaded	Ranch
85											Davis	81	UP	476306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
86											Davis	82	UP	47758	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
87											Davis	83	UP	176306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
88											Elk	84	CNW	15040	SH	Stock Car (Horse)	gr/ylw	40'	Empty	Ranch
89											Elk	85	TTPX	80252	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
90											Elk	86	TTPX	80316	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
91											Spokane	87	UP	59163	FM	Flat Car	Yellow	70'	loaded	Team Track	Loaded with 2 Trailers
92											Spokane	88	NH	84217	FM	Flat Car	Black	70'	Wire rolls	Spokane Yard
93											Elk	89	ELK	FM63234	FM	Flat Car	Black	70'	Logs	Logging Camp	Loaded with Logs
94											Elk	90	ELK	FM63235	FM	Flat Car	Black	70'	logs	Logging Camp	Loaded with Logs
95											Davis	91	BN	66208	FM	Flat Car	Green	41'	Rail load	Davis	Loaded with Rail
96											Davis	92	GN	66209	FM	Flat Car	Brown	41'	Rail load	Davis	Loaded with Rail
97											Elk	93	ELK	FL1003	FL	Logging Car	Black	40'	Logs	Logging Camp
98											Elk	94	ELK	FL1004	FL	Logging Car	Black	40'	Logs	Logging Camp
99											Elk	95	ELK	FL1005	FL	Logging Car	Black	40'	Logs	Logging Camp
Sheet1

Cell Formulas
Range	Formula
G1	G1	=TODAY()
A3	A3	=RANDBETWEEN(1,7)
D3	D3	=VLOOKUP($A$3,$L$118:$T$124,5,FALSE)
B5	B5	=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)

 

[Fluff]

Thanks for that. The problem is rows 31 & 32, if you clear them it will work

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Date:						05/04/2024
2	SET OUTS
3	3		Train:	#N/A			Location:	Elk			1	2	3	4	5	6	7	8	9	10	11
4			Location	Rpt. Marks	Number	AAR Type	LD/MTY	Destination	Notes		Block	ID	Rpt. Marks	Car No.	Type	Description	Color	Length	LD/MTY	Empty Return to 1	Notes
5	1	1	Elk	UP	65263	GB	Loaded	Elk Track 2	0		Elk	1	UP	65263	GB	Gondola	Yellow	41'	Loaded	Elk Track 2
6	2	2	Elk	SOUTHERN	1229	GB	Loaded	Elk Track 4	0		Elk	2	SOUTHERN	1229	GB	Gondola	Silver	41'	Loaded	Elk Track 4
7	3	6	Elk	CO	218892	GB	Loaded	Elk Track 5	0		Spokane	3	SOUTHERN	1230	GB	Gondola	Silver	41'	Empty	Team Track
8	4	7	Elk	ELK	GB1230	GB	Loaded	Elk Track 5	0		Spokane	4	CN	1231	GB	Gondola	Red	41'	Trash	Team Track
9	5	8	Elk	ELK	GB1231	GB	Empty	Elk Track 5	0		Spokane	5	North	1232	GB	Gondola	Black	48'	Trash	Team Track
10	6	9	Elk	ELK	GB1232	GB	Empty	Elk Track 5	0		Elk	6	CO	218892	GB	Gondola	Black	41'	Loaded	Elk Track 5
11	7	10	Elk	ELK	GB1233	GB	Empty	Elk Track 5	0		Elk	7	ELK	GB1230	GB	Gondola	Black	41'	Loaded	Elk Track 5
12	8	11	Elk	ACF	5250	HT	Loaded	Coop	0		Elk	8	ELK	GB1231	GB	Gondola	Black	41'	Empty	Elk Track 5
13	9	12	Elk	ACF	5251	HT	Loaded	Coop	0		Elk	9	ELK	GB1232	GB	Gondola	Black	41'	Empty	Elk Track 5
14	10	15	Elk	PRR	262581	HT	Empty	Elk Track 2	0		Elk	10	ELK	GB1233	GB	Gondola	Black	41'	Empty	Elk Track 5
15	11	19	Elk	WA	32985	LO	Empty	Elk Track 4	0		Elk	11	ACF	5250	HT	4 Bay Hopper	White	60'	Loaded	Coop
16	12	20	Elk	WA	32986	LO	Empty	Elk Track 4	0		Elk	12	ACF	5251	HT	4 Bay Hopper	White	60'	Loaded	Coop
17	13	21	Elk	B&O	837085	LO	Empty	Elk Track 4	0		Spokane	13	ATSF	301488	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
18	14	22	Elk	L&N	30069	LO	Empty	Elk Track 4	0		Spokane	14	ATSF	301489	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
19	15	38	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Elk	15	PRR	262581	HT	4 Bay Hopper	Brown	40'	Empty	Elk Track 2
20	16	39	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Spokane	16	ELK	HT1301	HT	4 Bay Hopper	Black	62'	Empty	Team Track
21	17	40	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Spokane	17	ELK	HT1302	HT	4 Bay Hopper	Black	62'	Empty	Team Track
22	18	41	Elk	CN	114132	MWD	Loaded	Deep Hole Mine	0		Spokane	18	ELK	HT1303	HT	4 Bay Hopper	Black	62'	Empty	Team Track
23	19	42	Elk	CN	114132	MWD	Loaded	Deep Hole Mine	0		Elk	19	WA	32985	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
24	20	43	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	20	WA	32986	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
25	21	44	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	21	B&O	837085	LO	3 Bay Hopper	Gray	45'	Empty	Elk Track 4
26	22	45	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	22	L&N	30069	LO	3 Bay Hopper	Brown	44'	Empty	Elk Track 4
27	23	46	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	23	BN	521476	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
28	24	47	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	24	BN	521477	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
29	25	48	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	25	BN	521478	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
30		49	Elk	BN	189784	XM	Empty	Track 1 Elk Yard	0		Spokane	26	BN	521479	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
31		50	Elk	B&O	11147	XM	Empty	Track 1 Elk Yard	0		Spokane	27	BN	521480	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
32		51	Elk	LV	41003	XM	Loaded	Monument Mnf	0		Spokane	28	BN	521481	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
33	1	52	Elk	LV	41004	XM	Loaded	Coop	0		Spokane	29	BN	521482	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
34	2	53	Elk	CN	553290	XAF	Empty	Coop	0		Spokane	30	BN	521483	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
35	3	54	Elk	NW	47500	XM	Empty	Monument Mnf	0		Spokane	31	MKT	10683	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
36	4	55	Elk	GN	20680	XM	Loaded	"Transfer n Storage"	0		Spokane	32	BN	163210	HT	90 Ton Hopper	Red		Loaded	Spokane Yard
37	5	56	Elk	GN	22020	XM	Loaded	"Transfer n Storage"	0		Spokane	33	RG	17491	HT	90 Ton Hopper	black		Loaded	Spokane Yard
38	6	57	Elk	BN	3407	XM	Loaded	Oil Depot	0		Spokane	34	BN	163210	HT	90 Ton Hopper	Alum.		Loaded	Spokane Yard
39	7	64	Elk	SF	55360	RCD	Loaded	Track 1 Elk Yard	0		Davis	35	ELK		HM	2 Bay Hopper	Black		Empty	Lumber Mill
40	8	67	Elk	LV	RCD71121	RCD	Empty	Track 2 Elk Yard	0		Davis	36	GN	176857	HM	2 Bay Hopper	Gray	20'	Empty	Lumber Mill
41	9	70	Elk	ELK	RCD71124	RCD	Empty	Track 2 Elk Yard	0		Davis	37	GN	176858	HM	2 Bay Hopper	White	20'	Empty	Lumber Mill
42	10	71	Elk	WSRX	238	T	Empty	Track 1 Elk Yard	0		Elk	38	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
43	11	72	Elk	SCCX	1245	T	Loaded	Track 1 Elk Yard	0		Elk	39	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
44	12	73	Elk	GN	1153	T	Empty	Track 1 Elk Yard	0		Elk	40	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
45	13	74	Elk	SCCX	1246	T	Loaded	Track 1 Elk Yard	0		Elk	41	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
46	14	75	Elk	SP	97732	TA	Empty	Track 1 Elk Yard	0		Elk	42	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
47	15	76	Elk	UC	97778	TA	Loaded	Track 2 Elk Yard	0		Elk	43	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
48	16	77	Elk	ATSF	582039	SM	Empty	Ranch	0		Elk	44	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
49	17	78	Elk	ELK	SM52148	SM	Empty	Ranch	0		Elk	45	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
50	18	79	Elk	D&RGW	62135	SM	Empty	Ranch	0		Elk	46	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
51	19	80	Elk	ATSF	50659	SM	Loaded	Ranch	0		Elk	47	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
52	20	84	Elk	CNW	15040	SH	Empty	Ranch	0		Elk	48	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
53	21	85	Elk	TTPX	80252	FB	Loaded	Lumber Store	Loaded with Lumber		Elk	49	BN	189784	XM	Boxcar	Green	40'	Empty	Track 1 Elk Yard
54	22	86	Elk	TTPX	80316	FB	Loaded	Lumber Store	Loaded with Lumber		Elk	50	B&O	11147	XM	Boxcar	Yellow	50'	Empty	Track 1 Elk Yard
55	23	89	Elk	ELK	FM63234	FM	Logs	Logging Camp	Loaded with Logs		Elk	51	LV	41003	XM	Boxcar	white	40'	Loaded	Monument Mnf
56	24	90	Elk	ELK	FM63235	FM	logs	Logging Camp	Loaded with Logs		Elk	52	LV	41004	XM	Boxcar	white	40'	Loaded	Coop
57	25	93	Elk	ELK	FL1003	FL	Logs	Logging Camp	0		Elk	53	CN	553290	XAF	BoxCar	Brown	60'	Empty	Coop
58		94	Elk	ELK	FL1004	FL	Logs	Logging Camp	0		Elk	54	NW	47500	XM	Boxcar	Black	40'	Empty	Monument Mnf
59		95	Elk	ELK	FL1005	FL	Logs	Logging Camp	0		Elk	55	GN	20680	XM	Boxcar	Green	40'	Loaded	"Transfer n Storage"
60											Elk	56	GN	22020	XM	Boxcar		40'	Loaded	"Transfer n Storage"
61											Elk	57	BN	3407	XM	Boxcar	Green	40'	Loaded	Oil Depot
62											Davis	58	WP	3301	XM	Boxcar	Brown	40'	Loaded	Davis
63											Davis	59	WP	61959	XM	Boxcar	Brown	40'	Empty	Davis
64											Davis	60	GN	11877	XM	Boxcar	Red	40'	Empty	Davis
65											Davis	61	VT	1015	XM	Boxcar	Brown	40'	Empty	Davis
66											Davis	62	rprx	507	RCD	Refer Boxcar	Yellow	40'	Loaded	Stock Yard
67											Davis	63	WA	3000	RCD	Refer Boxcar	Yellow	40'	Empty	Stock Yard
68											Elk	64	SF	55360	RCD	Refer Boxcar	Orange	50'	Loaded	Track 1 Elk Yard
69											Davis	65	SF	55361	RCD	Refer Boxcar	Orange	50'	Loaded	Meat Packing
70											Davis	66	LV	RCD71120	RCD	Refer Boxcar	white	50'	Empty	Meat Packing
71											Elk	67	LV	RCD71121	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
72											Davis	68	ELK	RCD71122	RCD	Refer Boxcar	white	50'	Loaded	Davis
73											Davis	69	ELK	RCD71123	RCD	Refer Boxcar	white	50'	Loaded	Davis
74											Elk	70	ELK	RCD71124	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
75											Elk	71	WSRX	238	T	Tank Car	Brown	40'	Empty	Track 1 Elk Yard
76											Elk	72	SCCX	1245	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
77											Elk	73	GN	1153	T	Tank Car	Black	40'	Empty	Track 1 Elk Yard
78											Elk	74	SCCX	1246	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
79											Elk	75	SP	97732	TA	Chemical Tank Car	Silver	40'	Empty	Track 1 Elk Yard
80											Elk	76	UC	97778	TA	Chemical Tank Car	white	40'	Loaded	Track 2 Elk Yard
81											Elk	77	ATSF	582039	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
82											Elk	78	ELK	SM52148	SM	Stock Car (Cattle)	Brown	40'	Empty	Ranch
83											Elk	79	D&RGW	62135	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
84											Elk	80	ATSF	50659	SM	Stock Car (Cattle)	Green	40'	Loaded	Ranch
85											Davis	81	UP	476306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
86											Davis	82	UP	47758	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
87											Davis	83	UP	176306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
88											Elk	84	CNW	15040	SH	Stock Car (Horse)	gr/ylw	40'	Empty	Ranch
89											Elk	85	TTPX	80252	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
90											Elk	86	TTPX	80316	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
91											Spokane	87	UP	59163	FM	Flat Car	Yellow	70'	loaded	Team Track	Loaded with 2 Trailers
92											Spokane	88	NH	84217	FM	Flat Car	Black	70'	Wire rolls	Spokane Yard
93											Elk	89	ELK	FM63234	FM	Flat Car	Black	70'	Logs	Logging Camp	Loaded with Logs
94											Elk	90	ELK	FM63235	FM	Flat Car	Black	70'	logs	Logging Camp	Loaded with Logs
95											Davis	91	BN	66208	FM	Flat Car	Green	41'	Rail load	Davis	Loaded with Rail
96											Davis	92	GN	66209	FM	Flat Car	Brown	41'	Rail load	Davis	Loaded with Rail
97											Elk	93	ELK	FL1003	FL	Logging Car	Black	40'	Logs	Logging Camp
98											Elk	94	ELK	FL1004	FL	Logging Car	Black	40'	Logs	Logging Camp
99											Elk	95	ELK	FL1005	FL	Logging Car	Black	40'	Logs	Logging Camp
Sheet6

Cell Formulas
Range	Formula
G1	G1	=TODAY()
A3	A3	=RANDBETWEEN(1,7)
D3	D3	=VLOOKUP($A$3,$L$118:$T$124,5,FALSE)
B5:I59	B5	=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)
Dynamic array formulas.

 

[Cwboysteve]

Thanks for that. The problem is rows 31 & 32, if you clear them it will work

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Date:						05/04/2024
2	SET OUTS
3	3		Train:	#N/A			Location:	Elk			1	2	3	4	5	6	7	8	9	10	11
4			Location	Rpt. Marks	Number	AAR Type	LD/MTY	Destination	Notes		Block	ID	Rpt. Marks	Car No.	Type	Description	Color	Length	LD/MTY	Empty Return to 1	Notes
5	1	1	Elk	UP	65263	GB	Loaded	Elk Track 2	0		Elk	1	UP	65263	GB	Gondola	Yellow	41'	Loaded	Elk Track 2
6	2	2	Elk	SOUTHERN	1229	GB	Loaded	Elk Track 4	0		Elk	2	SOUTHERN	1229	GB	Gondola	Silver	41'	Loaded	Elk Track 4
7	3	6	Elk	CO	218892	GB	Loaded	Elk Track 5	0		Spokane	3	SOUTHERN	1230	GB	Gondola	Silver	41'	Empty	Team Track
8	4	7	Elk	ELK	GB1230	GB	Loaded	Elk Track 5	0		Spokane	4	CN	1231	GB	Gondola	Red	41'	Trash	Team Track
9	5	8	Elk	ELK	GB1231	GB	Empty	Elk Track 5	0		Spokane	5	North	1232	GB	Gondola	Black	48'	Trash	Team Track
10	6	9	Elk	ELK	GB1232	GB	Empty	Elk Track 5	0		Elk	6	CO	218892	GB	Gondola	Black	41'	Loaded	Elk Track 5
11	7	10	Elk	ELK	GB1233	GB	Empty	Elk Track 5	0		Elk	7	ELK	GB1230	GB	Gondola	Black	41'	Loaded	Elk Track 5
12	8	11	Elk	ACF	5250	HT	Loaded	Coop	0		Elk	8	ELK	GB1231	GB	Gondola	Black	41'	Empty	Elk Track 5
13	9	12	Elk	ACF	5251	HT	Loaded	Coop	0		Elk	9	ELK	GB1232	GB	Gondola	Black	41'	Empty	Elk Track 5
14	10	15	Elk	PRR	262581	HT	Empty	Elk Track 2	0		Elk	10	ELK	GB1233	GB	Gondola	Black	41'	Empty	Elk Track 5
15	11	19	Elk	WA	32985	LO	Empty	Elk Track 4	0		Elk	11	ACF	5250	HT	4 Bay Hopper	White	60'	Loaded	Coop
16	12	20	Elk	WA	32986	LO	Empty	Elk Track 4	0		Elk	12	ACF	5251	HT	4 Bay Hopper	White	60'	Loaded	Coop
17	13	21	Elk	B&O	837085	LO	Empty	Elk Track 4	0		Spokane	13	ATSF	301488	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
18	14	22	Elk	L&N	30069	LO	Empty	Elk Track 4	0		Spokane	14	ATSF	301489	HT	4 Bay Hopper	Brown	60'	Loaded	Spokane Yard
19	15	38	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Elk	15	PRR	262581	HT	4 Bay Hopper	Brown	40'	Empty	Elk Track 2
20	16	39	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Spokane	16	ELK	HT1301	HT	4 Bay Hopper	Black	62'	Empty	Team Track
21	17	40	Elk	CN	114263	MWD	Loaded	Deep Hole Mine	0		Spokane	17	ELK	HT1302	HT	4 Bay Hopper	Black	62'	Empty	Team Track
22	18	41	Elk	CN	114132	MWD	Loaded	Deep Hole Mine	0		Spokane	18	ELK	HT1303	HT	4 Bay Hopper	Black	62'	Empty	Team Track
23	19	42	Elk	CN	114132	MWD	Loaded	Deep Hole Mine	0		Elk	19	WA	32985	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
24	20	43	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	20	WA	32986	LO	3 Bay Hopper	Tan	45'	Empty	Elk Track 4
25	21	44	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	21	B&O	837085	LO	3 Bay Hopper	Gray	45'	Empty	Elk Track 4
26	22	45	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Elk	22	L&N	30069	LO	3 Bay Hopper	Brown	44'	Empty	Elk Track 4
27	23	46	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	23	BN	521476	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
28	24	47	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	24	BN	521477	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
29	25	48	Elk	UP	26440	MWD	Loaded	Deep Hole Mine	0		Spokane	25	BN	521478	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
30		49	Elk	BN	189784	XM	Empty	Track 1 Elk Yard	0		Spokane	26	BN	521479	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
31		50	Elk	B&O	11147	XM	Empty	Track 1 Elk Yard	0		Spokane	27	BN	521480	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
32		51	Elk	LV	41003	XM	Loaded	Monument Mnf	0		Spokane	28	BN	521481	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
33	1	52	Elk	LV	41004	XM	Loaded	Coop	0		Spokane	29	BN	521482	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
34	2	53	Elk	CN	553290	XAF	Empty	Coop	0		Spokane	30	BN	521483	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
35	3	54	Elk	NW	47500	XM	Empty	Monument Mnf	0		Spokane	31	MKT	10683	HT	90 Ton Hopper	Black		Loaded	Spokane Yard
36	4	55	Elk	GN	20680	XM	Loaded	"Transfer n Storage"	0		Spokane	32	BN	163210	HT	90 Ton Hopper	Red		Loaded	Spokane Yard
37	5	56	Elk	GN	22020	XM	Loaded	"Transfer n Storage"	0		Spokane	33	RG	17491	HT	90 Ton Hopper	black		Loaded	Spokane Yard
38	6	57	Elk	BN	3407	XM	Loaded	Oil Depot	0		Spokane	34	BN	163210	HT	90 Ton Hopper	Alum.		Loaded	Spokane Yard
39	7	64	Elk	SF	55360	RCD	Loaded	Track 1 Elk Yard	0		Davis	35	ELK		HM	2 Bay Hopper	Black		Empty	Lumber Mill
40	8	67	Elk	LV	RCD71121	RCD	Empty	Track 2 Elk Yard	0		Davis	36	GN	176857	HM	2 Bay Hopper	Gray	20'	Empty	Lumber Mill
41	9	70	Elk	ELK	RCD71124	RCD	Empty	Track 2 Elk Yard	0		Davis	37	GN	176858	HM	2 Bay Hopper	White	20'	Empty	Lumber Mill
42	10	71	Elk	WSRX	238	T	Empty	Track 1 Elk Yard	0		Elk	38	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
43	11	72	Elk	SCCX	1245	T	Loaded	Track 1 Elk Yard	0		Elk	39	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
44	12	73	Elk	GN	1153	T	Empty	Track 1 Elk Yard	0		Elk	40	CN	114263	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
45	13	74	Elk	SCCX	1246	T	Loaded	Track 1 Elk Yard	0		Elk	41	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
46	14	75	Elk	SP	97732	TA	Empty	Track 1 Elk Yard	0		Elk	42	CN	114132	MWD	70 Ton Ore Car	Brown	20'	Loaded	Deep Hole Mine
47	15	76	Elk	UC	97778	TA	Loaded	Track 2 Elk Yard	0		Elk	43	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
48	16	77	Elk	ATSF	582039	SM	Empty	Ranch	0		Elk	44	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
49	17	78	Elk	ELK	SM52148	SM	Empty	Ranch	0		Elk	45	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
50	18	79	Elk	D&RGW	62135	SM	Empty	Ranch	0		Elk	46	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
51	19	80	Elk	ATSF	50659	SM	Loaded	Ranch	0		Elk	47	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
52	20	84	Elk	CNW	15040	SH	Empty	Ranch	0		Elk	48	UP	26440	MWD	70 Ton Ore Car	Silver	20'	Loaded	Deep Hole Mine
53	21	85	Elk	TTPX	80252	FB	Loaded	Lumber Store	Loaded with Lumber		Elk	49	BN	189784	XM	Boxcar	Green	40'	Empty	Track 1 Elk Yard
54	22	86	Elk	TTPX	80316	FB	Loaded	Lumber Store	Loaded with Lumber		Elk	50	B&O	11147	XM	Boxcar	Yellow	50'	Empty	Track 1 Elk Yard
55	23	89	Elk	ELK	FM63234	FM	Logs	Logging Camp	Loaded with Logs		Elk	51	LV	41003	XM	Boxcar	white	40'	Loaded	Monument Mnf
56	24	90	Elk	ELK	FM63235	FM	logs	Logging Camp	Loaded with Logs		Elk	52	LV	41004	XM	Boxcar	white	40'	Loaded	Coop
57	25	93	Elk	ELK	FL1003	FL	Logs	Logging Camp	0		Elk	53	CN	553290	XAF	BoxCar	Brown	60'	Empty	Coop
58		94	Elk	ELK	FL1004	FL	Logs	Logging Camp	0		Elk	54	NW	47500	XM	Boxcar	Black	40'	Empty	Monument Mnf
59		95	Elk	ELK	FL1005	FL	Logs	Logging Camp	0		Elk	55	GN	20680	XM	Boxcar	Green	40'	Loaded	"Transfer n Storage"
60											Elk	56	GN	22020	XM	Boxcar		40'	Loaded	"Transfer n Storage"
61											Elk	57	BN	3407	XM	Boxcar	Green	40'	Loaded	Oil Depot
62											Davis	58	WP	3301	XM	Boxcar	Brown	40'	Loaded	Davis
63											Davis	59	WP	61959	XM	Boxcar	Brown	40'	Empty	Davis
64											Davis	60	GN	11877	XM	Boxcar	Red	40'	Empty	Davis
65											Davis	61	VT	1015	XM	Boxcar	Brown	40'	Empty	Davis
66											Davis	62	rprx	507	RCD	Refer Boxcar	Yellow	40'	Loaded	Stock Yard
67											Davis	63	WA	3000	RCD	Refer Boxcar	Yellow	40'	Empty	Stock Yard
68											Elk	64	SF	55360	RCD	Refer Boxcar	Orange	50'	Loaded	Track 1 Elk Yard
69											Davis	65	SF	55361	RCD	Refer Boxcar	Orange	50'	Loaded	Meat Packing
70											Davis	66	LV	RCD71120	RCD	Refer Boxcar	white	50'	Empty	Meat Packing
71											Elk	67	LV	RCD71121	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
72											Davis	68	ELK	RCD71122	RCD	Refer Boxcar	white	50'	Loaded	Davis
73											Davis	69	ELK	RCD71123	RCD	Refer Boxcar	white	50'	Loaded	Davis
74											Elk	70	ELK	RCD71124	RCD	Refer Boxcar	white	50'	Empty	Track 2 Elk Yard
75											Elk	71	WSRX	238	T	Tank Car	Brown	40'	Empty	Track 1 Elk Yard
76											Elk	72	SCCX	1245	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
77											Elk	73	GN	1153	T	Tank Car	Black	40'	Empty	Track 1 Elk Yard
78											Elk	74	SCCX	1246	T	Tank Car	Orange	40'	Loaded	Track 1 Elk Yard
79											Elk	75	SP	97732	TA	Chemical Tank Car	Silver	40'	Empty	Track 1 Elk Yard
80											Elk	76	UC	97778	TA	Chemical Tank Car	white	40'	Loaded	Track 2 Elk Yard
81											Elk	77	ATSF	582039	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
82											Elk	78	ELK	SM52148	SM	Stock Car (Cattle)	Brown	40'	Empty	Ranch
83											Elk	79	D&RGW	62135	SM	Stock Car (Cattle)	Green	40'	Empty	Ranch
84											Elk	80	ATSF	50659	SM	Stock Car (Cattle)	Green	40'	Loaded	Ranch
85											Davis	81	UP	476306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
86											Davis	82	UP	47758	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
87											Davis	83	UP	176306	SM	Stock Car (Cattle)	Yellow	40'	Empty	Stock Yard
88											Elk	84	CNW	15040	SH	Stock Car (Horse)	gr/ylw	40'	Empty	Ranch
89											Elk	85	TTPX	80252	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
90											Elk	86	TTPX	80316	FB	Bulk Head Flat Car	Brown	55'	Loaded	Lumber Store	Loaded with Lumber
91											Spokane	87	UP	59163	FM	Flat Car	Yellow	70'	loaded	Team Track	Loaded with 2 Trailers
92											Spokane	88	NH	84217	FM	Flat Car	Black	70'	Wire rolls	Spokane Yard
93											Elk	89	ELK	FM63234	FM	Flat Car	Black	70'	Logs	Logging Camp	Loaded with Logs
94											Elk	90	ELK	FM63235	FM	Flat Car	Black	70'	logs	Logging Camp	Loaded with Logs
95											Davis	91	BN	66208	FM	Flat Car	Green	41'	Rail load	Davis	Loaded with Rail
96											Davis	92	GN	66209	FM	Flat Car	Brown	41'	Rail load	Davis	Loaded with Rail
97											Elk	93	ELK	FL1003	FL	Logging Car	Black	40'	Logs	Logging Camp
98											Elk	94	ELK	FL1004	FL	Logging Car	Black	40'	Logs	Logging Camp
99											Elk	95	ELK	FL1005	FL	Logging Car	Black	40'	Logs	Logging Camp
Sheet6

Cell Formulas
Range	Formula
G1	G1	=TODAY()
A3	A3	=RANDBETWEEN(1,7)
D3	D3	=VLOOKUP($A$3,$L$118:$T$124,5,FALSE)
B5:I59	B5	=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)
Dynamic array formulas.

This is great, Thank you for your help.
Thanks for your patience, and teaching me a few things.
Steve.

 

[Fluff]

You're welcome & thanks for the feedback.