Results 1 to 5 of 5

Concatenation of Text in Arrays with reference cells

Threaded View

boscoamd Concatenation of Text in... 11-30-2011, 06:19 AM
Special-K Re: Concatenation of Text in... 11-30-2011, 09:18 AM
boscoamd Re: Concatenation of Text in... 11-30-2011, 09:48 AM
boscoamd Re: Concatenation of Text in... 11-30-2011, 09:50 AM
martindwilson Re: Concatenation of Text in... 11-30-2011, 10:10 AM
  1. #1
    Registered User
    Join Date
    11-29-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Concatenation of Text in Arrays with reference cells

    Hi,

    Please help with the below.

    I want to concatenate the Values in an array based on a reference cell.
    For example if Column A and B have the following values.. I want to concatenate the vlaues of Array B for A1 in cell C1.

    In other words from the below list I want to concatenate all the matching fruits in column B tagged to each digit in Column A and this concatenated value to be available in Column C for each reference cell.

    For easy reference I have attached a sample file. XLSX


    A B C(Desired Result)
    1 Apple Apple,Orange,Pine
    1 Apple Apple
    3 Orange Orange,Peach
    4 Pine Pine,Peach
    5 Peach Peach
    6 Peach Peach
    2 Pine Pine
    3 Peach Orange,Peach
    4 Peach Pine,Peach
    1 Orange Pine,Peach
    1 Pine Pine,Peach
    Attached Files Attached Files
    Last edited by boscoamd; 11-30-2011 at 06:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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