+ Reply to Thread
Results 1 to 5 of 5

Help - Possible Macro or?? Concatenate + If formula?

  1. #1
    Registered User
    Join Date
    05-22-2014
    Posts
    2

    Help - Possible Macro or?? Concatenate + If formula?

    Hello,

    I'm an intermediate excel user.

    I am trying to reformat a spreadsheet that takes the following into consideration:

    Column A is a name -- Column B is a description for the name in A, but covers multiple rows (was exported from a software program).

    I need to come up with a formula that will recognize that if there is no value in Column A, that the text in B should be concatenated to the text in the row above, and that if the text in the row above was already concatenated to the row above that, then the text should be concatenated to that row instead (and so on and so forth).

    Is this possible? Would save me around 10-15+ hours of cut and paste.

    Thanks,
    KB
    Last edited by kbee859; 05-30-2014 at 07:59 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Help - Possible Macro or?? Concatenate + If formula?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in C2 and below will give you the concatenated column B cells in the row before the next name, but it will have all the intermediate steps as well. To do what you want in the row with the name in it will require an array formula.

  3. #3
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Help - Possible Macro or?? Concatenate + If formula?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    should do it the other way.

  4. #4
    Registered User
    Join Date
    05-22-2014
    Posts
    2

    Re: Help - Possible Macro or?? Concatenate + If formula?

    Thanks gak67 - I will work with this today - thanks so much for the help!

  5. #5
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├┤ Pew Pew
    Posts
    441

    Re: Help - Possible Macro or?? Concatenate + If formula?

    A macro would make an easy solution. Are you wanting to do this for every row in the sheet? Do you want the blank rows then deleted out after the concatenation happens?

    If so something like this would work, assuming the data is on a tab called Sheet1

    Please Login or Register  to view this content.
    Always a good idea to make a test copy before running code that deletes information because there is no Undo for macro code.

+ 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] Macro to Concatenate, copy and paste the formula until the last row of the previous column
    By venkat.ramamoordhy1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2013, 04:03 PM
  2. Macro problem using 'Concatenate' formula to calculate Age
    By Ardiko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2012, 08:22 PM
  3. CONCATENATE Macro or Formula
    By mgreene in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2010, 09:25 AM
  4. Macro concatenate formula
    By vipjun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2006, 03:47 PM
  5. using the value of a macro variable in a concatenate formula
    By Simon W in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2006, 07:20 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