Hi all,

I think my problem is very simple for you to solve it.

I have a situation like this: I have 10 numbers, than I want to have the product of combination of this numbers by 2, 3, 4, 5, 6, 7, 8, 9, 10 (see example below)

cell A1=2;cell A2=2.5;cell A3=2.75;cell A4=2.33;cell A5=3;cell A6=3.3;cell A7=2.66;cell A8=2.8;cell A9=2.9;cell A10=3.5;

If I'll combine as 2 I'll have : cellA1*cellA2=2*2.5=5 ; cell1*cell3=2*2.75=5.5 .... and so on

If I'll combine as 3 I'll have : cellA1*cellA2*cellA3=2*2.5*2.75=13.75 ....and so on

If I'll combine as 4 I'll have : cellA1*cellA2*cellA3*cellA4= ..... and so on

If I'll combine as 5, as 6, ... as 10!

If I'll combine as 2 I'll have 45 max combination

If I'll combine as 3 I'll have 120 max combination

If I'll combine as 4 I'll have 210 max combination

If I'll combine as 5 I'll have 252 max combination

If I'll combine as 6 I'll have 210 max combination

If I'll combine as 7 I'll have 120 max combination

If I'll combine as 8 I'll have 45 max combination

If I'll combine as 9 I'll have 10 max combination

If I'll combine as 10 I'll have 1 max combination

Can I make this with a formula in excel or I need VB for this? If I'll use VB I need the code.

Many thanks,

Tudor