hi,
Although i understand permutations i cant find a quick and easy way to
multiply all the combinations for a permuation. Doing it long hand works but
is time consuming as i currently have 2 rows with a total of 165
combinations.

In row 1 i have 10 numbers, perming 8 from 10 giving me 45 combinations,
perming 7 from 10 giving me 120 combinations

Is there an easy way to multiply these combinations.

My 10 numbers are in C1:L1 and each permutation is to be multiplied and
then multiplied again by B2.

I hope this is clear enough to understand.

Thanks