Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Permutation combinations and multiplying them
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 |