Hello all,
I am new to the forums and new to advanced excel applications. I can do your basic functions and recording macros but that is about the extent of my knowledge. I am now working on trying to build a simulation in excel that will tag unique data based on a user input.

Heres the situation:
We have several manufacturing lines that make different color and material widgets. Some of the manufacturing lines run the exact same widgets (color and material). While some make very unique color/material combos. We are now looking to idle some of the lines (take out of service tempararily) and I'm trying to figure out how to pull (mark/tag/identify somehow) the unique widgets that are ran per any given line.

So for example: I say idle line 10, excel will then display all the unique widgets ran to line 10 and ran no where else but line 10.

My data looks like this:

PRODUCT GROUP FLOWSTREAM GRADE COLOR LINE
LFS NAT ML9383 116 29
LFS OPAQ ML9383 701 30
NOQ NAT HPS2 1125 10
NOQ NAT HPS2 1125 11
NOQ NAT HPS2 1125 29

So for example, if you idle line 10 it would not tag NOQ NAT HPS2 1125 as a hit, because it can be made on another line. I hope that makes sense as this data is 30,000 long haha.

Thanks