I need to find number combinations ranging from 1-30, no repeating numbers, and each set appearing in a different column.
Help?
2007-01-27 14:37:36 · 3 answers · asked by Josh G 1 in Computers & Internet ➔ Programming & Design
I'm assuming what you want is something like this: in col A, rows 1-30, each of the numbers 1 to 30 in random order; in col. B, rows 1-30, the same set of numbers 1 to 30 in a different random order, etc.
If that's true, you will need a Visual Basic function macro. I have one from the book by John Walkenbach, Excel 2002 Power Programming with VBA. It should work with any version beginning with Excel 97.
You can find the macro by "searching the book" on Amazon -- search for "RANDOMINTEGERS()" Or post an email address, and I'll send you a spreadsheet containing the macro.
2007-01-28 06:55:25 · answer #1 · answered by Joliet Jake 3 · 0⤊ 0⤋
=FACT(30)
The number of combinations of a set of 30 unique numbers is (30!) thirty factorial. That's 30*29*28*27*...*3*2*1 which is approximately 2.65253E+32
2007-01-27 15:36:28 · answer #2 · answered by nospamcwt 5 · 0⤊ 1⤋
An example of what you have and what you need would probably help get an answer. I for one don't understand what you're looking for.
2007-01-27 15:21:17 · answer #3 · answered by BigRez 6 · 0⤊ 1⤋