+ Reply to Thread
Results 1 to 7 of 7

Parent/child values grouping

  1. #1
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Parent/child values grouping

    Please have a look at the following Google spreadsheet:

    https://docs.google.com/spreadsheets...it?usp=sharing

    Columns B and C are dynamic (number of lines always growing)

    I believe Column E and my comment on cell E15 are self explanatory to show what I would like to achieve.

    Many thanks for any kind help.

    Octavio

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,139

    Re: Parent/child values grouping

    Do you have a solution for this already?

    If so, then have the courtesy to tell us so we don't need to waste our time.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2407
    Posts
    26,153

    Re: Parent/child values grouping

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

    (Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Re: Parent/child values grouping

    Hello to all,
    In fact, a solution has been set up for this issue. I was in a hurry and really needed to found a solution so posted my question elsewhere.
    You can find the solution here:
    https://docs.google.com/spreadsheets...it?usp=sharing

    All the best,
    Octavio

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Parent/child values grouping

    Being in a hurry does not mean that you can choose to ignore our rules.

    Thanks for the link, however it is a link to the question asked on the other forum (Google Support) that we need, not a link to the workbook.

    Please now mark this thread as solved.
    Last edited by AliGW; 08-24-2023 at 02:45 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  6. #6
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Re: Parent/child values grouping

    Hello,
    I apologize for the cross-posting. Here is the link to the discussion (although it is more explicitly stated in the spreadsheet).

    https://support.google.com/docs/thre...gid=231690705#
    Octavio

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2501 (Windows 11 24H2 64-bit)
    Posts
    89,058

    Re: Parent/child values grouping

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Grouping of child parts and sun in Parent in Hierarchy -Multilevel
    By kapil D in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2021, 12:23 PM
  2. parent and child reports with vba
    By jondidi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2019, 10:42 PM
  3. [SOLVED] Parent Child relationship issue: Get parent ID for child
    By masterl1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-28-2018, 07:35 AM
  4. [SOLVED] Looking up all the child values associated with one parent value
    By cwwazy in forum Excel General
    Replies: 7
    Last Post: 08-03-2015, 04:09 PM
  5. [SOLVED] Parent child relationships(working out parent item) for each item
    By grphillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-21-2013, 05:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1