Posted to microsoft.public.excel.worksheet.functions

Gaurav[_3_] Gaurav[_3_] is offline

external usenet poster

Posts: 127

RANDBETWEEN

Hi All,

If I use RANDBETWEEN function to generate random samples, how do I make sure
that units are not repeate?

For example-

I have 1000 units and I have to generate 30 samples. I will use
RANDBETWEEN(1,30) in 30 cells. How do I make sure that the numbers are not
repeated and all the samples are unique?

Thanks in advance for any help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
randbetween(1.1,1.25)	Deniz	Excel Worksheet Functions	3	July 10th 07 04:40 PM
RANDBETWEEN	pkeegs	Excel Worksheet Functions	6	April 27th 07 01:12 AM
RANDBETWEEN	Michel AUDIFFREN	Excel Discussion (Misc queries)	0	February 26th 06 11:02 PM
Randbetween	Gbonda	Excel Discussion (Misc queries)	1	June 30th 05 02:39 PM
randbetween gives ?NAME	Kristjan_Thor	Excel Discussion (Misc queries)	5	March 14th 05 11:41 PM

All times are GMT +1. The time now is 04:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us