I realize this will require a lot of paper to print out 100,000 numbers but this is what I want to do. I need all 100,000 'combinations' from 00000 to 99999 on a printable speadsheet. Sequential is fine but random would be better so long as all 100,000 possible combinations are there without repeats.
2006-11-30 16:09:58 · 5 answers · asked by autosyte 1 in Science & Mathematics ➔ Mathematics
can excel do random numbers? can you make a program to autofill a column sequentially? i'm not sure & don't have excel handy right now. but if those two things are possible, here's my idea...
in column A, fill it with all the numbers from 0 to 99999 sequentially. surely if there is not a function that does this, a macro could be created easily that would. next, use a random number function to fill column B. Then, sort the two lists by column B. Delete B if you want. What is left should be a randomly sorted list.
2006-11-30 16:41:33 · answer #1 · answered by coop 2 · 0⤊ 0⤋
This is quite feasible. Are you looking for random numbers in a list, for example, all down the A column in Excel, or printed across the entire sheet, so as to save paper?
2006-11-30 16:21:09 · answer #2 · answered by RulerOf 1 · 0⤊ 0⤋
Interesting!
2006-11-30 16:12:11 · answer #3 · answered by modulo_function 7 · 0⤊ 0⤋
Search for a permutation program online, or try the computer section in Yahoo Answers(if there is one) for a function in Excel that can do this.
2006-11-30 16:38:49 · answer #4 · answered by zeromeyzl 2 · 0⤊ 0⤋
How about 00000-99999, that works for me.
2006-11-30 16:20:06 · answer #5 · answered by themountainviewguy 4 · 0⤊ 0⤋