Hello,
I have a list of part #'s that has the original part in column A and the replacement part in column B. I need to build this into a list that references all part #'s that are associated to the newest part in the supersede chain. Where part A is replaced by part B and that is replaced by part C, etc.. I have been able to put those numbers all in a row using Vlookup. What I am having difficulty figuring out how to accomplish is looking for other parts in the worksheet that should also be included in the row and then combine this information and eliminate duplicates. On the attached worksheet I have colored all the cells that contain part # 5214-077. I would like to take all that information and list all parts the newest part replaces in a single row on a new sheet with the newest part (Column G) shown in column A. The corresponding values would be in individual cells starting with column B in that row. It would also be ok if all the data was placed in column B separated with commas. The the process would then need to repeat, looking at each unique part # in column F and returning 1 row for each individual part # with the value in column F shown in Column A, repeated again for columns E, D, & C. Is this possible in Excel? Any help is appreciated.
Bookmarks