unique parent/child sets

sshone1

New Member
Joined
Jun 14, 2013
Messages
10
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
 

Attachments

  • SharedScreenshot.png
    SharedScreenshot.png
    134.5 KB · Views: 16

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,141,121
Messages
5,704,421
Members
421,347
Latest member
vrajesh544

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top