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

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