ExcelBanter - View Single Post - Permutation combinations and multiplying them

Phil

thanks

"Toppers" wrote in message
...
Phil,
E-mail me [ toppers<atjohntopley.fsnet.co.uk] and I'll send you a
workbook with a permutation/combination macro.

"Phil" wrote:

I have 10 numbers C1:L1
i.e. 5 , 2 , 3 , 6 , 7 , 8, 2 , 12 , 52, 19
Perming any 8 of these numbers and multiplying them together gives me a
total of 45 multiplications.
i.e. 5*2*3*6*7*8*2*12 =241920 is 1
2*3*6*7*8*2*12*52 =2515968 is a 2nd

There are 45 of these to do so is there a formula to calculate these
permutations by just entering the original 10 numbers? I cant write VB.

"shail" wrote in message
oups.com...
Sorry Phil

I didn't understand it. may be you can make me understand some other
way.

Thanks

Shail

Phil wrote:
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