How to create a macro in excel so that it can generate a list ofunique records using all permutation

R

Rizwan

Hi,

I have a table in excel which has 12 rows and 13 columns:

Ex.
AB BD CJ DG EH FK GD HF II JK KG LN MO
FG IY JH GJ GT GG RT IF GG HH HD OD DO
..
..
..
so on till Row 12

I need a macro such that it can create all permutations and
combinations and populate a table such that every record(row) is
unique and has covered all possible combinations.

Ex.
Combination 1:
AB BD CJ DG EH FK GD HF II JK KG LN MO
AB IY CJ DG EH FK GD HF II JK KG LN MO
AB BD JH DG EH FK GD HF II JK KG LN MO
so on....

Any help will be highly appreciated.

Thanks
Riz
 
P

Pete_UK

Do you realize how many potential combinations you could have from 12
rows and 13 columns? (Hint: type =12^13 in a cell somewhere).

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top