Results 1 to 5 of 5

Combining multiple cells with text

Threaded View

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2007
    Posts
    61

    Combining multiple cells with text

    Column A are various names of which many are duplicated.
    Column B are various text phrases associated with the names in column A.

    I would like to make a function in column C that will combine the text in column B into the the corresponding cell in column C that represents the first instance of a name in column A.

    So here is an example of what I would like to do:

    Column A
    Name A
    Name A
    Name B
    Name C

    Column B
    Yellow
    Purple
    Red
    Blue

    Column C
    Yellow, Purple
    (Blank)
    Red
    Blue

    Any suggestions?
    Last edited by dforte; 08-05-2010 at 09:31 PM.

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