Macro to concatenate unique combinations??

**oubravs2b** · 09-10-2009, 04:25 PM

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!!

**karan** · 09-10-2009, 04:47 PM

Hi,

Use this code:

Please Login or Register  to view this content.

I have attached the file for your reference. Be sure to 'Enable Macros'.

--Karan--

**shg** · 09-10-2009, 04:48 PM

How about formulas instead:

Please Login or Register  to view this content.

You can use A4:Bn as indices to to do the catenation.

**oubravs2b** · 09-10-2009, 05:04 PM

Works like a charm karan! Thanks a TON!!

**mrroling2000** · 04-09-2011, 08:52 PM

Originally Posted by karan

Hi,

Use this code:

Please Login or Register  to view this content.

I have attached the file for your reference. Be sure to 'Enable Macros'.

--Karan--

So how would you change this so you would have a 5 number combo. say you have these numbers 1,2,3,4,5,6

1,2,3,4,5
1,3,4,5,6
1,2,4,5,6
and so on...

**xaddict** · 07-02-2012, 08:27 AM

Originally Posted by mrroling2000

So how would you change this so you would have a 5 number combo. say you have these numbers 1,2,3,4,5,6

1,2,3,4,5
1,3,4,5,6
1,2,4,5,6
and so on...

I would also like to know that..;

**arlu1201** · 07-02-2012, 08:29 AM

Xaddict,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.