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.
Any idea?
I can calculate the number of rows needed for level 1 by countif(submember,list of submembers) but what about deeper levels? Macro would contain many nested conditions I suppose...
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.

Any idea?
I can calculate the number of rows needed for level 1 by countif(submember,list of submembers) but what about deeper levels? Macro would contain many nested conditions I suppose...