Re: Generating Random numbers.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

See help on RAND function.

Basic usage...............

In A1 enter = RAND() and copy down as far as you wish.

You may get duplicates using this method.

See John McGimpsey's site for Random numbers with no duplicates.

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


Gord Dibben MS Excel MVP

On Sat, 22 Sep 2007 13:08:01 -0700, Tyler <Tyler@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I need to generate a set of random numbers. I know there is a way to do this;
I just do not know how to find it. Please help me

.

Relevant Pages

  • modules and random numbers
    ... I've been using the rand function but it seems ... The number of duplicates goes up exponentially as I generate ... someone give me a short snippet of code to show how I would generate a ... Dan Miller ...
    (perl.beginners)
  • math::trulyrandom
    ... I've been using the rand function but it seems ... The number of duplicates goes up exponentially as I generate ... someone give me a short snippet of code to show how I would generate a ... Dan Miller ...
    (comp.lang.perl.modules)
  • Re: math::trulyrandom
    ... The number of duplicates goes up exponentially as I generate ... numbers in the required range using only perl's ... rand function. ... sub create_rand { ...
    (comp.lang.perl.modules)
  • Re: VLOOKUP and RAND question
    ... no duplicates in column 1 with differing numbers in ... > Since there is equal probability of the numbers in Column 1 to appear, ... > can I just use the RAND function for Column 2 and skip the first step I ...
    (microsoft.public.excel.misc)
  • Re: Best way to delete duplcate records in a table.
    ... John V. Smith 37 Main Street.... ... So finding dupes is usually human manual comparing and editing. ... It is better to try to avoid duplicates up front, at user entry time, ...
    (microsoft.public.access.formscoding)