+ Reply to Thread
Results 1 to 5 of 5

Concatenating values two columns (column B, column C) based on criterion

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Concatenating values two columns (column B, column C) based on criterion

    Hi.
    I need to concatenate the values ​​of two columns (Column B and Column C), based on criterion between columns A, B, C.

    I try adapt this topic, but i can't.
    http://www.excelforum.com/excel-gene...atenation.html

    Thank you!
    Attached Files Attached Files
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Concatenating values two columns (column B, column C) based on criterion

    Hello marreco,

    The attached workbook has the macro below added to it. There is a button on the worksheet to run the macro.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Concatenating values two columns (column B, column C) based on criterion

    Try the attached.
    Attached Files Attached Files
    Last edited by AB33; 05-15-2014 at 05:37 PM.

  4. #4
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Concatenating values two columns (column B, column C) based on criterion

    Hi, very good.

    both code work perfectly!

    thank you!!!!

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Concatenating values two columns (column B, column C) based on criterion

    Hello marreco,

    You're welcome. Thanks for marking this post solved.

+ 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. [SOLVED] filter and clean cells based on another criterion column
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2014, 03:46 PM
  2. [SOLVED] Counting entries in columns and concatenating headers in keyword column
    By lsmcal1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2013, 05:52 AM
  3. Replies: 4
    Last Post: 06-06-2012, 02:15 PM
  4. Conditional Formatting based on criterion in changing columns values
    By simon123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2011, 12:59 PM
  5. For n rows, determine if sum of column values matches criterion
    By SKAh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2010, 01:08 PM

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