Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to permutate three arrays of numbers in
Excel? For instance: Array 1: [a,b,c,d] Array 2: [A,B,C,D] Array 3: [1,2,3,4] I want to solve for every singe combination of Array 1 * Array 2 * Array 3 (a*A*1, a*A*2, a*A*3, etc.). Is it possible to automate this process by writing a macro or VB Script or by another method? Your help is very much appreciated. |