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 |
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) |