excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
i'm trying to figure out some calculation through excel
if i need to choose 6 numbers out of 37
but i want to force that 1 number will return from last draw (1-2-3-4-5-6)
so i thought:
COMBIN(36,5)*6 = 376,992 x 6 = 2,261,952
while the all is =COMBIN(37,6) = 2,324,784
but if for example i took from last draw the number 2 and the next five can be from the 36 remaining, let's say 2-4-10-11-22-33
but if i take the number 4 and the next five could be the same 4-2-10-11-22-33
is that right? the calc?
same for 2 from last draw and 4 out of 35 remaining
=COMBIN(35,4)*COMBIN(6,2)
or 2 from last 2 draws
=COMBIN(35,4)*COMBIN(12,2)
3455760 which is wrong....why?
and so on....
if it is, i want to build in excel a larger table with same principles, but in larger scale, draws, and etc
i'm trying to figure out some calculation through excel
if i need to choose 6 numbers out of 37
but i want to force that 1 number will return from last draw (1-2-3-4-5-6)
so i thought:
COMBIN(36,5)*6 = 376,992 x 6 = 2,261,952
while the all is =COMBIN(37,6) = 2,324,784
but if for example i took from last draw the number 2 and the next five can be from the 36 remaining, let's say 2-4-10-11-22-33
but if i take the number 4 and the next five could be the same 4-2-10-11-22-33
is that right? the calc?
same for 2 from last draw and 4 out of 35 remaining
=COMBIN(35,4)*COMBIN(6,2)
or 2 from last 2 draws
=COMBIN(35,4)*COMBIN(12,2)
3455760 which is wrong....why?
and so on....
if it is, i want to build in excel a larger table with same principles, but in larger scale, draws, and etc
Last edited: