How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column
 

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

How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column
 

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

On Aug 6, 11:45*am, Rizwan wrote:
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