Results 1 to 7 of 7

Macro to concatenate unique combinations??

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Kansas City
    MS-Off Ver
    Excel 2007
    Posts
    2

    Macro to concatenate unique combinations??

    Thanks in advance for any help!

    I have the following example values in Column A and I want to concatenate each unique combination to a list.

    A
    B
    C
    D

    Example necessary output:

    A vs. B
    A vs. C
    A vs. D
    B vs. C
    B vs. D
    C vs. D

    Notice there are no duplicates (e.g., A vs. B / B vs. A). I have found many macros that will create all the duplicates but none that will create only unique. Thanks again!!
    Last edited by oubravs2b; 09-10-2009 at 05:10 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