Results 1 to 2 of 2

Thread: Convert list to tree
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    May 2015
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Convert list to tree

    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?

  2. #2
    Board Regular
    Join Date
    May 2015
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Convert list to tree

    Note the problem was posted on other forum as well: https://www.excelforum.com/excel-gen...t-to-tree.html

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •