Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How count these combinations ?
Me again, still counting combinations.. till now every given info here to me is working and i learned a lot... but still not smart enough to find the next result.. so.. -- Got list lotto combinations (A1 till F3000) -- List of 6 nr each line -- All numbers from (1 to 42) Now ...how can i calculate how much times off the 3000 lines these kind of combinations exists.. -- combination of 2 numbers -- combi of 3 and 4 numbers *i think it's maybe to complex to make such a kind of program*... but maybe possible to calculate the combi of 2 numbers and a (input cell) to check manualy for combi's of a 3th or 4th number ....out of the list It would be kind of the one who knows a good solution to my problem Greetings... -- Jacko ------------------------------------------------------------------------ Jacko's Profile: http://www.excelforum.com/member.php...o&userid=28762 View this thread: http://www.excelforum.com/showthread...hreadid=484686 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How count these combinations ?
Hello Jacko, If you are calculating combinations then the formula is nCk. Where n i number of objects, 42 in your case, and k is the number of groups ( numbers at a time). To calculate the combinations the formula would be (42*41*40*39*38*37)/(6*5*4*2*1) = 5,245,786 I don't think 3000 lines is enough space for your combinations. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=48468 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How count these combinations ?
I wouild read the requests something like this:
given a list of 3000 sets of six number lottery numbers, count the combinations that contain each set of combinations of 2 numbers drawn from 1 to 42. I assume also for 3 and 4. your formula can be done with the built in worksheet formula for combinations =combin(42,6) In a previous post, Jacko received code that generates combinations. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello Jacko, If you are calculating combinations then the formula is nCk. Where n is number of objects, 42 in your case, and k is the number of groups (6 numbers at a time). To calculate the combinations the formula would be: (42*41*40*39*38*37)/(6*5*4*2*1) = 5,245,786 I don't think 3000 lines is enough space for your combinations. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=484686 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF, AND combinations | Excel Worksheet Functions | |||
Loop through Combinations and Keep a Count | Excel Programming | |||
Combinations | Excel Worksheet Functions | |||
count combinations | Excel Discussion (Misc queries) | |||
Count combinations | Excel Programming |