Concatenate based on values in another column
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Concatenate based on values in another column

  1. #11
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,805
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Concatenate based on values in another column

    Try
    Code:
    ' Removes Brackets
        Cells.Replace What:=" (*)", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    Note the space before the bracket
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  2. #12
    New Member
    Join Date
    May 2019
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate based on values in another column

    Quote Originally Posted by Fluff View Post
    Try
    Code:
    ' Removes Brackets
        Cells.Replace What:=" (*)", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    Note the space before the bracket
    Nice one sir!

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,805
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Concatenate based on values in another column

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #14
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,805
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Concatenate based on values in another column

    For future reference

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #15
    New Member
    Join Date
    May 2019
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate based on values in another column

    Apologies for the cross posting - certainly won't be doing that again especially with how helpful this place is

    I'm revisiting my file and wondered if it's possible to tweak and to apply a minimum and maximum date. Basically, this is my data

    PARTNO1 Hyundai Accent 01/01/94 31/12/99
    PARTNO1 Hyundai i30 01/01/98 31/12/16
    PARTNO1 Hyundai i40 01/01/99 31/12/17
    PARTNO2 Hyundai Accent 01/01/94 31/12/99
    PARTNO2 Subaru Impreza 01/01/93 31/12/98
    PARTNO2 Toyota Celica 01/01/95 31/12/01
    PARTNO3 Toyota Celica 01/08/94 31/05/02
    PARTNO3 Toyota MR2 01/01/91 31/12/01


    Using this fine thread I have the necessary code to put all applications on one line and also on how to seperate Column 2.
    But...how would I incorporate the date? So based on the above sample, the output would be as follows:


    PARTNO1 Hyundai Accent, i30, i40 01/94>12/17
    PARTNO2 Hyundai Accent 01/94>12/99. Subaru Impreza 01/93>12/98. Toyota Celica 01/95>12/01
    PARTNO3 Toyota Celica, MR2 08/94>05/02


    Trying best to explain but basically it now groups up the dates by Car manufacturer (Column 2). So PARTNO1 is Hyundai with a minimum date value of 01/94 and a maximum date value of 12/17.
    PARTNO2, Hyundai's Min and Max is 01/94>12/99 and so on.


    Thank you for any help
    Last edited by Steve1977; Jun 18th, 2019 at 10:53 AM. Reason: improved wording

  6. #16
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,805
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Concatenate based on values in another column

    This is totally different question & needs a new thread please.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •