Random Range with no duplicates

[Darmahart]

Here is my situation: I have a list of college classes. With each class -
lets say ENGL-1301 I need to generate a series of random section numbers with
no duplicates between 9001-9099. Then on the next class such as ENGL-1302 I
need to start over with the number system. There are different numbers of
classes in one class name - lets say ENGL-1301 has 20 sections and ENGL-1302
has 9 sections.

Thanks for any help!

 

[Skinman]

This may be the formula you are seeking
=RANDBETWEEN(9001,9099)
Skinman

 

[Darmahart]

I tried that function, but it does produce duplicates. I can't have duplicate
numbers, but thanks!

 

[Gary''s Student]

In E1 thru E99 enter 9001 thru 9099.
In F1 thru F99 enter =RAND()

Sort columns E & F by F

If you want three random values, pick E1, E2, and E3
If you want four random values, pick E1, E2, E3, and E4

To re-shuffle, just re-sort

 

[Ak Man]

U can use this vba code:

Randomize
Cells(1, 9) = Int(99 * Rnd + 9001)
For i = 2 To 99
Do
Stopind = False
Randomize
x= Int(99 * Rnd + 9001)
Set foundCell = Range("I1", _
Range("I1").End(xlDown).Address).Find(x)
If Not (foundCell Is Nothing) Then
Stopind = True
End If
Loop Until Not Stopind
Cells(i, 9) = x
Next

 

[Darmahart]

Very simple yet effective. Thanks!

 

[Bernd P]

Hello,

I suggest to use my UDF UniqRandInt:
http://www.sulprobil.com/html/uniqrandint.html

Regards,
Bernd