Hello, in the sample data attached I Start with a BOM hierarchy found in column B through E. I use a formula in column A to get the number level of the BOM. I have a very clunky macro that will list the parent next to its child in column F.
Using some very clunky formulas and macros I can get a filter for unique parents to get a list of children, however, as you can see in the data set, there are multiple identical parents and it brings in duplicate children nodes. If I can get a count of how many children to each parent I can fake the results and delete true duplicates.
What would be really cool is if someone could help me with a macro that will give each parent with the true set of children. Any help would be great... Thanks
Using some very clunky formulas and macros I can get a filter for unique parents to get a list of children, however, as you can see in the data set, there are multiple identical parents and it brings in duplicate children nodes. If I can get a count of how many children to each parent I can fake the results and delete true duplicates.
What would be really cool is if someone could help me with a macro that will give each parent with the true set of children. Any help would be great... Thanks