Generate random numbers 1-100 without any repeats?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I generate random numbers from 1 to 100 without any repeated numbers?
Am using Excel 2003.
 
Hi,

In cell A1 type =RAND() and copy that down to A100. In cell B1 type:

=MATCH(LARGE($A$1:$A$100,ROW()),$A$1:$A$100,0)

and copy that down to B100.

Now in column B you should have numbers 1-100 that are unique and in
random order.

Of course there is a slight change that Excels RAND function returns
same number twice or more in a group of hundred, but that change is
something like 1:1E13.

- Asser
 
Back
Top