Posted on other forum as well: https://www.mrexcel.com/forum/excel-...ml#post5067309
-----------------------------------
Hi,
I have 2 column table (name, subname). I would like to look up whether each subname for a given name is also used as a name and has a subname. If yes, add this subname behind original subname and repeat for the new subname unless no subname is left, then next row.
gAOFqOD.jpg
Any idea?
I can calculate the number of rows needed for level 1 by countif(submember,list of submembers) but what about deeper levels?
Bookmarks