Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random number generation
Hello...Hopefully somebody can help, because I no longer remember how to do this. I am trying to populate a random number list. I need 137 different random numbers , with the numbers between 10000 and 99999. If anyone knows how to do this, you are my hero. Thanks! -- scotjo ------------------------------------------------------------------------ scotjo's Profile: http://www.excelforum.com/member.php...o&userid=30206 View this thread: http://www.excelforum.com/showthread...hreadid=498872 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random number generation
First off, you'll need the "Analysis TookPak" Add-In installed. To do this,
click TOOLS, then ADD-INS, then check the box next to "Analysis TookPak". Then you can use the following formula: =RANDBETWEEN(10000,99999) HTH, Elkar "scotjo" wrote: Hello...Hopefully somebody can help, because I no longer remember how to do this. I am trying to populate a random number list. I need 137 different random numbers , with the numbers between 10000 and 99999. If anyone knows how to do this, you are my hero. Thanks! -- scotjo ------------------------------------------------------------------------ scotjo's Profile: http://www.excelforum.com/member.php...o&userid=30206 View this thread: http://www.excelforum.com/showthread...hreadid=498872 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random number generation
also if you need unique numbers just search for random number generator in
excel worksheet functions on this site, there is one there that should help with that, oh and that formula randomizes everytime you recalculate, so just press F9 to recalculate. "Elkar" wrote: First off, you'll need the "Analysis TookPak" Add-In installed. To do this, click TOOLS, then ADD-INS, then check the box next to "Analysis TookPak". Then you can use the following formula: =RANDBETWEEN(10000,99999) HTH, Elkar "scotjo" wrote: Hello...Hopefully somebody can help, because I no longer remember how to do this. I am trying to populate a random number list. I need 137 different random numbers , with the numbers between 10000 and 99999. If anyone knows how to do this, you are my hero. Thanks! -- scotjo ------------------------------------------------------------------------ scotjo's Profile: http://www.excelforum.com/member.php...o&userid=30206 View this thread: http://www.excelforum.com/showthread...hreadid=498872 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random number generation
If you *don't* have the ATP installed, you can use this formula:
=INT(RAND()*90000+10000) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Elkar" wrote in message ... First off, you'll need the "Analysis TookPak" Add-In installed. To do this, click TOOLS, then ADD-INS, then check the box next to "Analysis TookPak". Then you can use the following formula: =RANDBETWEEN(10000,99999) HTH, Elkar "scotjo" wrote: Hello...Hopefully somebody can help, because I no longer remember how to do this. I am trying to populate a random number list. I need 137 different random numbers , with the numbers between 10000 and 99999. If anyone knows how to do this, you are my hero. Thanks! -- scotjo ------------------------------------------------------------------------ scotjo's Profile: http://www.excelforum.com/member.php...o&userid=30206 View this thread: http://www.excelforum.com/showthread...hreadid=498872 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random number generation
Hello,
Select cells A1:A137 and enter =UniqRandInt(99999-10000+1)+10000-1 as array formula (press CTRL + SHIFT + ENTER to enter) Use my UDF UniqRandInt() from http://www.sulprobil.com/html/uniqrandint.html A small optimization: set #Const LATE_INITIALISATION = TRUE This will speed up the routine a little bit. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Graph with Random Number Generator | Charts and Charting in Excel | |||
random number without repeating? | Excel Worksheet Functions | |||
generating random number as template | Excel Discussion (Misc queries) | |||
Auto generation of 3 levels of running number | Excel Worksheet Functions | |||
Random number generator | Excel Worksheet Functions |