I have a list of 12 probabilities in cells A1-A12. Of these, I need the product/multiplication of all combin(12,7) = 792 probabilities. Is there a quick way of doing this? I can't seem to get my head round to a solution.
I have a list of 12 probabilities in cells A1-A12. Of these, I need the product/multiplication of all combin(12,7) = 792 probabilities. Is there a quick way of doing this? I can't seem to get my head round to a solution.
Hi clattenburg,
See the below discussion already happened in forum:-
http://www.excelforum.com/excel-form...epetition.html
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks