How to generate a list of pairs for all combination possible?

Hi Everyone,

I would like to generate in Excel a list of all possible pairs from a set list of names.
Please do you have any idea how to do it? I have Pop Tool added to Excel but I have no ideaof which kind of formula to use.

For example if my set list is:
Name 1
Name 2
Name 3
Name 4

I would like to have, in two columns:
Column 1 Column 2

Name 1 Name 1
Name 1 Name 2
Name 1 Name 3
Name 1 Name 4
....


Thank you very much.

Here's one way, with names in column A, it will give you a list in C:D:

Please Login or Register  to view this content.

You placed a question in the programming forum, so we presume you are familiar with the basics.

Follow these instructions to activate your Developer Tab on the Ribbon: http://office.microsoft.com/en-us/ex...010014113.aspx


How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Select it from the macro list while your list of names is on the activesheet in column A.

UPDATE: Here's another code option that will not use the same name in a single match row and won't do duplicates, all results will be unique pairs.

Please Login or Register  to view this content.