Is there a way to have Excel pick a list of random numbers without picking the same number twice? I am probably the *most* basic user of Excel so I would not be able to use any advance features like VBA but I can certainly handle formulas. Thank you! roadmax
Pick Random Numbers



Re: Pick Random Numbers
Hi buddy  a warm welcome to OzGrid.
I have locked this feed  will delete it at a later date, You have asked the same question twice see:
http://www.ozgrid.com/forum/showthread.php?t=10108
Can i kindly ask you read teh terms and conditions you have agreed to on signing up with OzGid see:
http://www.ozgrid.com/forum/showthread.php?t=20947
This is know as duplicate posting, one of those things the members hate. Have a good read of the link its easy stuff, and will make life rich and rewarding  the gusy here are fab and help a lot  you have good answer or the othe question feed.
Hope you understand and see my point  not to mention adding to my Admin duties.
Many thansk for yoru kindness and undersatnding
Jack

Re: Pick Random Numbers
There is probably a more elegant way to do this, but what comes to my mind is to generate a list of random numbers larger than you need, and then use
DATA > FILTER > ADVANCED FILTER > Check "Unique Records Only" and "Copy to Another Location"
which will produce a list of unique numbers. If you need 100, take the first 100 from the second (unique) list.
To generate the first list of random numbers, use the RAND() function. It generates random numbers (with lots of decimal places) between zero and one. If you need integers between 0 and 1000, then use
=INT(RAND()*1000)
in each cell to generate the first list.
For real numbers between zero and 10,000 use
=RAND()*10000
For numbers between 100 and +100 use:
=RAND()*200100
And so forth.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!