About Us

Tim Williams

mike,

don't have anything in VB, but if you know any javascript you could
try translating this:

tim

<html
<head
<titleCombinations</title

<script type="text/javascript"

// Given an array of arrays of various lengths,
// return an array of arrays where
// "numRows" = product of all array lengths
// "numCols" = length of original array parameter
// Assume all passed arrays hold only unique values
function GetCombinations(arr){

var arrReturn=new Array(); // returned array
var nProduct;
var repeats;
var tmp;

// find product of the array lengths
nProduct=1;
for(x=0;x<arr.length;x++)nProduct=nProduct*arr[x].length;

// initialise the final array
for(n=0;n<nProduct;n++) arrReturn[n]=new Array();

repeats=nProduct;

for(idx=0;idx<arr.length;idx++){

tmp=arr[idx];
repeats=repeats/tmp.length;
z=0;
//loop through each value in arr[idx], repeating it [repeat] times,
//do this nProduct/(arr[idx]*repeats) times
for(a=0;a<(nProduct/(tmp.length*repeats));a++){
for(n=0;n<tmp.length;n++){
for(m=1;m<=repeats;m++){
arrReturn[z][idx]=tmp[n];
z++;
}
}
}
}

return arrReturn;
}

</script

</head

<body

<script type="text/javascript"

var tmp;
var arr1=new Array("A","B");
var arr2=new Array("1","2","3");
var arr3=new Array("W","X","Y","Z");
var arr4=new Array("K","L","M","N","P");

var newArr=GetCombinations(new Array(arr1,arr2,arr3,arr4));

document.write("<h3" + newArr.length + "items: </h3");

for(x=0;x<newArr.length;x++){
document.write(newArr[x].join(" - ") + "<br");
}
</script
</body
</html

"Rob van Gelder" wrote in
message ...
Permutation is your keyword here.

Try this post by Leo Heuser

http://groups.google.co.nz/groups?se...&output=gplain

Rob

"Mike" wrote in message
...
Hello all,

Man, am I stuck. I need to write some VB code that will
take answers to a questionnaire and produce a spreadsheet
listing every possible combination of answers. For
example, there are three questions, each with three
answers: a, b, or c. I need the output to be:

a a a
b a a
c a a
a b a
a c a
a a b
etc...

Can anybody think of a way to make this happen?

I appreciate any and all help.

Thanks in advance and have a great one,

Mike

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Interesting problem in excel, producing a list for aspecific date	mark	Excel Discussion (Misc queries)	3	August 17th 09 10:56 PM
how can i get a list of combinations?	Pastor Pudge	Excel Discussion (Misc queries)	1	December 25th 08 08:45 PM
Producing an automated list from a large list	Chuckee	Excel Worksheet Functions	0	February 26th 07 04:00 PM
Producing an automated list from a larger list	Chuckee	Excel Worksheet Functions	2	February 26th 07 12:31 PM
Formula for producing one list from another !	Chuckee	Excel Worksheet Functions	2	February 21st 07 11:15 PM

Menu

About Us