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

[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

 

[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