Random Sample Generation

markkramer · May 10th, 2002, 10:26 AM

We'd like to randomly select 80 numbers from a specified list of 1200 values. While the =RAND() function returns a random value between 0 and 1, is there a way to use it or some other function to randomly generate a number from a range, say 1-1200.

Any help would be appreciated!

Thanks!

Mark and Jessica

Mark O'Brien · May 10th, 2002, 10:29 AM

Hi guys,

How about:



RANDBETWEEN(bottom,top)



Bottom   is the smallest integer RANDBETWEEN will return.



Top   is the largest integer RANDBETWEEN will return.

Please God no! Not another huge *** random number discussion. We all accept that these will just be pseudo-random. (sorry, don't ask)

jeffmfrank · May 10th, 2002, 11:10 AM

To get RANDBETWEEN, you need to install the analysis tool pak in the Add-Ins from the Tools menu.

markkramer · May 10th, 2002, 11:17 AM

Thanks!

The RANDBETWEEN() function was precisely what we were looking for!

And I looked in the archives to find how to use the advanced filter to remove duplicates.

This is an excellent forum!

Thanks again!!!!

Mark & Jessica

Jay Petrulis · May 10th, 2002, 12:44 PM

Quote:

On 2002-05-10 09:29, Mark O'Brien wrote:
---snip---
Please God no! Not another huge *** random number discussion. We all accept that these will just be pseudo-random. (sorry, don't ask)

Why not? I am deeply hurt that this particular topic can't go another round.

Wouldn't it be such great fun to redo it?

Kidding, big time!

Bye,
Jay

May 10th, 2002, 10:29 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Hi guys, How about: RANDBETWEEN(bottom,top) Bottom is the smallest integer RANDBETWEEN will return. Top is the largest integer RANDBETWEEN will return. Please God no! Not another huge *** random number discussion. We all accept that these will just be pseudo-random. (sorry, don't ask) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 10:26 AM	#1
markkramer Board Regular Join Date: May 2002 Location: San Diego Posts: 147	We'd like to randomly select 80 numbers from a specified list of 1200 values. While the =RAND() function returns a random value between 0 and 1, is there a way to use it or some other function to randomly generate a number from a range, say 1-1200. Any help would be appreciated! Thanks! Mark and Jessica

May 10th, 2002, 11:10 AM	#3
jeffmfrank Board Regular Join Date: Feb 2002 Location: Arizona Posts: 72	To get RANDBETWEEN, you need to install the analysis tool pak in the Add-Ins from the Tools menu.

May 10th, 2002, 11:17 AM	#4
markkramer Board Regular Join Date: May 2002 Location: San Diego Posts: 147	Thanks! The RANDBETWEEN() function was precisely what we were looking for! And I looked in the archives to find how to use the advanced filter to remove duplicates. This is an excellent forum! Thanks again!!!! Mark & Jessica