Results 1 to 2 of 2

Thread: Concatenate Break Formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2013
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Concatenate Break Formula

    Hi,

    The below table represents what I am currently doing manually but would am trying to come up with a formula to do for me. Or, some combination of formulas to get to the result I need.

    I need to write the result in the HTML column Currently I'm using the concatenation formula in the Formula column. It is simply concatenating the html tags and the data in the Description column for every cell where the Prod Ref # is the same. I'm copying / pasting the formula into the cell where the next Prod Ref # changes and removing the cell references or adding cell references as necessary to the formula. It's VERY time consuming and inefficient.

    I have a .xls with 10,000's of lines. I can't figure out how to automatically break and start a new concatenation formula as the Prod Ref # changes.

    Any Suggestions?

    Thanks.

    Prod Ref # Description Formula HTML
    201000 DESC1 '=CONCATENATE("
    ",B2,"

    ",B3,"

    ",B4,"

    ",B5,"

    ",B6,"

    ",B7,"
    ")
    DESC1

    DESC2

    DESC3

    DESC4

    DESC5

    DESC6
    201000 DESC2
    201000 DESC3
    201000 DESC4
    201000 DESC5
    201000 DESC6
    201002
    DESC1
    '=CONCATENATE("
    ",B8,"

    ",B9,"

    ",B10,"
    ")
    DESC1

    DESC2

    DESC3
    201002
    DESC2
    201002
    DESC3
    201004
    DESC1
    '=CONCATENATE("
    ",B11,"

    ",B12,"

    ",B13,"

    ",B14,"

    ",B15,"
    ")
    DESC1

    DESC2

    DESC3

    DESC4

    DESC5
    201004
    DESC2
    201004
    DESC3
    201004
    DESC4
    201004
    DESC5

  2. #2
    Board Regular
    Join Date
    Oct 2015
    Location
    South Wales
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate Break Formula

    Use two formulae. Column C to build up the concatenation, and column D to only show it on the first row of a product.
    Put these formulae in C2 and D2, then copy down:
    =B2&IF(A2=A3,C3,"")
    =IF(A1=A2,"",C2)

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
  •