Home > Forum Home > Automating Data Analysis Tasks > Generating possible Combination on a 6 by 6 table Share

Generating possible Combination on a 6 by 6 table

Excel Help for Generating Possible Combination On A 6 By 6 Table in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Generating Possible Combination On A 6 By 6 Table

Rate this:
(3/5 from 1 vote)
ConfusedI really need some assistance to develop an analysis system using excel for my research. I was wondering whether anybody can assist me here.

My sets of data are normally tabulated in the following manner (either a 6 by 6 table or 4 by 4 table)

Excel Spreadsheet:
 ABCDEF
1

 a






2

 g






3

 m






4

 s






5

 y


 1




6

 5






I need to tabulate the possible 6 digit combination using the 6*6 table above. The numbers cell that for the combination has to be link. I.e:- iouty6 or ahnu12 or 94xqjd.

Does any one know how to develop the above in excel sheet? 

I am not an expert in VBA. So if you can show me how it is done step-by-step, I would appreciate it very much. I can also me contacted through email at [email protected]. thank you 
 suthesh
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
ConfusedThe output you needs is somewhat unclear

can you please explain a bit more about what you need
 PD
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Generating possible Combination on a 6 by 6 table in the