Thread: Combinations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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