PC Review


Reply
Thread Tools Rate Thread

assigning random numbers without repetition

 
 
=?Utf-8?B?QmFoYQ==?=
Guest
Posts: n/a
 
      2nd Nov 2006
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      2nd Nov 2006
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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:03 PM.