assigning random numbers without repetition

's Computer Specifications

hi
I want to assign random numbers from 1 to 50 to the range of A1:A20 without
repetition.I checked several related questions but really couln`t understand
how this works.
thanks for help.
--
Regards,
Baha

's Computer Specifications

I like J.E. McGimpsey's UDF.

You can find it here:

http://www.mcgimpsey.com/excel/udfs/randint.html

Baha wrote:
>
> hi
> I want to assign random numbers from 1 to 50 to the range of A1:A20 without
> repetition.I checked several related questions but really couln`t understand
> how this works.
> thanks for help.
> --
> Regards,
> Baha

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Random number with no repetition?	Terry Pinnell	Microsoft Excel Misc	2	10th Jun 2007 11:10 AM
random limited repetition from array...	mj.clift@virgin.net	Microsoft C# .NET	4	28th Jun 2006 06:43 PM
Non-random numbers generated by excel's data analysis random gener	=?Utf-8?B?QWxsaWU=?=	Microsoft Excel Worksheet Functions	10	17th Sep 2005 06:19 AM
Re: Non-random numbers generated by excel's data analysis random gener	Harlan Grove	Microsoft Excel Misc	2	13th Sep 2005 04:06 PM
Assigning random #'s	=?Utf-8?B?YmdhcmV5?=	Microsoft Access	5	28th May 2005 12:02 AM