Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
I know how to get one random number by just using "RAND(x,y)" but how do I get 100 random numbers? -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
http://www.uis.edu/ctl/training/deta...ingnumbers.htm A little insight on random() -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
http://www.tushar-mehta.com/excel/ne..._and_sort.html
-- Kind regards, Niek Otten "ddawg09" wrote in message ... I know how to get one random number by just using "RAND(x,y)" but how do I get 100 random numbers? -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
What if you only want random numbers within a given range. I need 100 numbers between 5.5 and 10.5 but I did the Randombetween function and dragged it down but all it did was pretty much copy. -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
That is covered very well in the Excel help look up RAND
and I can't improve on that part. I could point you to a macro I use. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ddawg09" wrote in message ... What if you only want random numbers within a given range. I need 100 numbers between 5.5 and 10.5 but I did the Randombetween function and dragged it down but all it did was pretty much copy. -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
ddawg09 Wrote: What if you only want random numbers within a given range. I need 100 numbers between 5.5 and 10.5 but I did the Randombetween function and dragged it down but all it did was pretty much copy. Don't know if you've got the right formula (RANDBETWEEN will only give you integers) but if you dragged formula down and the result in each cell is the same then calculation may be set to manual. Hit F9 to re-calculate or set calculation to Automatic using Tools menu and Options.... -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to generate a bunch of random numbers???
Hi!
If you're using the RANDBETWEEN function it only returns integers (whole numbers). You could try this: =RANDBETWEEN(55,105)/10 Biff "ddawg09" wrote in message ... What if you only want random numbers within a given range. I need 100 numbers between 5.5 and 10.5 but I did the Randombetween function and dragged it down but all it did was pretty much copy. -- ddawg09 ------------------------------------------------------------------------ ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205 View this thread: http://www.excelforum.com/showthread...hreadid=521543 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i generate random numbers between 10000 and 65000 | Excel Discussion (Misc queries) | |||
random numbers, how can you utilize it without repeating them | Excel Discussion (Misc queries) | |||
GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
How do I generate random lottery numbers in Excel? | Excel Worksheet Functions | |||
Random Numbers | Excel Worksheet Functions |