Results 1 to 8 of 8

Looking for a macro or function to concatenate every unique combination

Threaded View

centralcb Looking for a macro or... 07-11-2012, 04:41 PM
natefarm Re: Looking for a macro or... 07-11-2012, 05:09 PM
centralcb Re: Looking for a macro or... 07-12-2012, 10:05 AM
natefarm Re: Looking for a macro or... 07-12-2012, 12:05 PM
centralcb Re: Looking for a macro or... 07-12-2012, 12:36 PM
centralcb Re: Looking for a macro or... 07-16-2012, 04:00 PM
natefarm Re: Looking for a macro or... 07-16-2012, 05:06 PM
centralcb Re: Looking for a macro or... 07-16-2012, 05:10 PM
  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Indianapolis
    MS-Off Ver
    Excel 2010
    Posts
    5

    Smile Looking for a macro or function to concatenate every unique combination

    Hi everyone,

    I am working on a project where I have 12 adjective keywords (N2:Y2) and 4 noun keywords (J2:M2). I need to concatenate every unique(no repeating words) combination of these two groups so that it looks like:

    N J
    N K
    N L
    N O J
    N O K
    N O L
    N O M
    etc...

    If there is a blank in any of the keyword cells for a combination, I would like the corresponding concatenated cell to be blank as well. I would like to put the first concatenated cell in Z2, keeping all concatenations in the same row.

    I've attached a test file below. Any help would be greatly appreciated! Thanks!
    Attached Files Attached Files

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