Trying to find the all possible combinations

**mutu** · 07-28-2009, 07:54 AM

Hey all,

I have the excel sheet below. In the sheet, I have models, body, lenght, engine... and I am trying to find all possible combinations.

ex:
Model Body Lenght Engine Power Steering ClassofVehicle Doors AC
M D J 4 4 L 3 8 M
M D J 4 4 M 2 7 F

LİST GOES LİKE THAT.

Is it possible to have it with visual basic, ı couldnt figure it out.

**royUK** · 07-28-2009, 08:08 AM

You probably need to be looking at Solver

**mutu** · 07-28-2009, 10:45 AM

Thanks for the reply, but I dont get the relation of this kind of problem with solver.

Thanks.

**SDruley** · 07-28-2009, 01:26 PM

Assuming that each letter of the alphabet is used and each digit of the decimal system is used your number of permutations is:

N = 26^2 * 26^2 * 26^2 * 10^2 * 10 ^2 * 26^2 * 10^2 * 10^2 * 26^2 = 1.41167E+22

You will have to define a narrower range to each parameter in order to make the field set more practical.

Once this is done you can write a macro to populate the combinations.

**shg** · 07-28-2009, 02:08 PM

For the options you have listed, there are over 2 billion combinations. Excel would explode before you listed them all.

**mutu** · 07-29-2009, 06:54 AM

what about this table?

is it logical?

**SDruley** · 07-29-2009, 11:11 AM

For a pivot it is not. Each column of the pivot must be the lowest common demoninator of stratification. Variables should not be combined in columns. Try giving me a table with just letters or numbers that represent singular dimensions of your field. Leave the descriptions to look-up tables.