ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Number combinations (https://www.excelbanter.com/excel-worksheet-functions/73863-number-combinations.html)

xy

Number combinations
 
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 :-)

Biff

Number combinations
 
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 :-)




Herbert Seidenberg

Number combinations
 
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



All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com