Results 1 to 7 of 7

Concatenate values from columns and deleting duplicates

Threaded View

RandomP Concatenate values from... 12-14-2011, 04:10 PM
Special-K Re: Concatenate values from... 12-14-2011, 04:58 PM
RandomP Re: Concatenate values from... 12-15-2011, 03:06 PM
Kelshaer Re: Concatenate values from... 12-15-2011, 03:47 PM
Steffen Thomsen Re: Concatenate values from... 12-15-2011, 03:54 PM
RandomP Re: Concatenate values from... 12-15-2011, 05:16 PM
Kelshaer Re: Concatenate values from... 12-15-2011, 06:20 PM
  1. #1
    Registered User
    Join Date
    11-23-2006
    Posts
    9

    Concatenate values from columns and deleting duplicates

    Hello,

    In the following example I have 5 columns with values (codes). I need to concatenate in a single cell the values from the 5 columns, deleting the duplicate values. Please see the sheet attached.

    Is there a formula, or maybe a macro that can help me?

    Thank you to all.
    Attached Files Attached Files
    Last edited by RandomP; 12-15-2011 at 06:36 PM.

Thread Information

Users Browsing this Thread

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

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