Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with algorithm
I am stuck, will much appreciate advice.
I have several vertical ranges with several values in each. I need to construct their possible combinations. For example, if range 1 contains values 1, 2 , range 2 : A, B, range 3: X, Y, Z then the result should look like this: 1 A X 1 A Y 1 A Z 1 B X 1 B Y 1 B Z 2 A X 2 A Y 2 A Z 2 B X 2 B Y 2 B Z I am trying to come up with a general algorithm to construct this output in Excel (because I don't know the number of ranges and number of values in them in advance, they vary). It looks like a job for the recursion, but I could not figure out how. Please help! Thanks in advance - RADO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix multiplication algorithm | Excel Discussion (Misc queries) | |||
searching for my perfect algorithm.... | Excel Discussion (Misc queries) | |||
Curve fitting algorithm | Charts and Charting in Excel | |||
looking for my perfect algorithm | Excel Discussion (Misc queries) | |||
Algorithm Challenge | Excel Worksheet Functions |