How to get Excel to list all possible combinations

**holmerz** · 11-23-2009, 05:06 AM

Hi again

I have been doing some combination of a list of values manually, and it's getting a bit tedious, to be honest.

So I was wondering if one can get excel to list all combinations of values from a list of values.

In the attached workbook "C1:C5" contains the values to be combined and the cells "B1:B5" the number of times the value is to be used and finally cell "A1:A5" contains the names corresponding to the values.

In column "F" I have listed all the possible combinations and in column "E" the corresponding combinations of names.

Any help will be highly appreciated.

In advance thank
Erik

**zbor** · 11-23-2009, 06:05 AM

Try look this for now...

Value_Comb(1).xls

However, right now I just wrote in Row1 values manually, and I need to get them automaticaly from table below, but I don't have time right now.. So I hope this is OK just for start...