+ Reply to Thread
Results 1 to 5 of 5

Concatenate result in one cell

  1. #1
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Concatenate result in one cell

    Please may someone out there could help me. I been trying to figure out how to do this for a few days with no success. I have a name on sheet 2 cell A3, and I have a list of names on sheet 1 Column B, I need to return what is on column C on the same row number the name is on column B if the name on sheet 2 cell A3 Match the name on the list on sheet 1 column B. My result in the one cell should look like: 2002-2003 / 2004-2005 / 2006-2007 / 2008-2009 in one cell because that name in sheet 2 cell A3 is 4 times on sheet 1 column B, let said (B20, B100, B150, B200) and sheet 1 column C20=2002-2004, C100=2004-2005, C150=2006-2007, C200=2008-2007

    Many thanks in advance. any help is really appreciated.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Concatenate result in one cell

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Concatenate result in one cell

    Hello
    Check the attached
    I have used a UDF
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  4. #4
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Re: Concatenate result in one cell

    Thanks a lot for this sourabhg98 , your xample works great and does what i need but i adjusted the array formula to my needs and return #name? may the UDF have to be modify?
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Quote Originally Posted by sourabhg98 View Post
    Hello
    Check the attached
    I have used a UDF
    Last edited by score; 02-28-2015 at 01:45 PM.

  5. #5
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Re: Concatenate result in one cell

    sourabhg98, Thank you, thank you, thank you!! Very Nice, i got it to work!!
    Quote Originally Posted by sourabhg98 View Post
    Hello
    Check the attached
    I have used a UDF

+ 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] concatenate result into a formula?
    By HDeuce in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-14-2013, 05:33 AM
  2. CONCATENATE Result
    By Koda7 in forum Excel General
    Replies: 2
    Last Post: 05-23-2011, 11:54 AM
  3. result of concatenate
    By Bakar in forum Excel General
    Replies: 2
    Last Post: 05-13-2011, 01:45 PM
  4. Excel 2007 : Summation of a concatenate result
    By superkid in forum Excel General
    Replies: 7
    Last Post: 02-14-2009, 02:41 AM
  5. Concatenate dates - getting odd result
    By irish1two3 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 03-16-2007, 05:39 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