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.

 

[Fluff]

Hi & welcome to MrExcel.
Which version of Excel does this have to work in?

 

[Cwboysteve]

360

 

[Cwboysteve]

Hi & welcome to MrExcel.
Which version of Excel does this have to work in?

365.

 

[Fluff]

Thanks for that.
Clear all formulae from columns B:I & put this in B5 only

=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)

 

[Cwboysteve]

Thanks for that.
Clear all formulae from columns B:I & put this in B5 only

=CHOOSECOLS(FILTER(K5:U99,K5:K99=H3),2,1,3,4,5,9,10,11)

4​	Train:	#3258-GP30 High noes
	Int	Rpt. Marks	Number	AAR Type
1	#CALC!​
2
3

 

[Fluff]

That error suggests that there is nothing in K5:K99 that matches H3

 

[Cwboysteve]

I'm having problems adding the add on to my excel. How can I get you the spreadsheet to see what I have? I'm not looking to have you fix it, (I can't learn that way) but at least you'll understand what I have.

 

[Fluff]

In what way isn't the add-in working?
Have you had a look here XL2BB Icons greyed out

 

[Cwboysteve]

I'm having problems adding the add on to my excel. How can I get you the spreadsheet to see what I have? I'm not looking to have you fix it, (I can't learn that way) but at least you'll understand what I have