Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Looked & read 'til I'm sick in the head :-(
Can someone please provide an excel formula for the following: all number combinations 4 numbers per combo numbers 1,2,3,4,5,6,7,8,9,0 I've tried "Combination" over and over without luck. I am a non-numeric person so 123 for Dummys would be very appreciated (frankly, someone can email me the results if that's easier for you) Thanks for letting whine :-) |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi!
See this: http://tinyurl.com/6okbp I just ran it using your criteria and it produced 210 combinations in less than 1 second. Biff "xy" wrote in message ... Looked & read 'til I'm sick in the head :-( Can someone please provide an excel formula for the following: all number combinations 4 numbers per combo numbers 1,2,3,4,5,6,7,8,9,0 I've tried "Combination" over and over without luck. I am a non-numeric person so 123 for Dummys would be very appreciated (frankly, someone can email me the results if that's easier for you) Thanks for letting whine :-) |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
This site generates 200 of the combinations for you:
http://theory.cs.uvic.ca/~cos/amof/e_comb.html Choose n=10 and k=4 and List Elements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
number format | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |