Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a list of permutations and combinations? | Excel Discussion (Misc queries) | |||
How to create a complete list of combinations from 5 options | Excel Discussion (Misc queries) | |||
Can I create a macro to generate an email once the data is entered | Excel Discussion (Misc queries) | |||
Permutations or Combinations or some other function?? | Excel Discussion (Misc queries) | |||
Macro to add numbers to create combinations that equal certain amo | Excel Discussion (Misc queries) |