Combinations
=COMBIN(13,3)
Please remember that Excel has a Help function, and if you'd tried typing
the word "combinations" into there it would have given you a clue.
--
David Biddulph
"Balaji" wrote in message
...
I have 13 values and I need the sum of 3 combinations.(i.e
(13*12*11)/(1*2*3)
totalling to 286 cmbination values.this is to map some value which is
hiding
in these combinations.Apart from manally creating this combination ,IS
there
any short method/work sheet function which can make this faster?
Please advice.
Balaji
|